I have 2 questions.
Attached is a sample workbook.
Question 1 - how do i calculate the days in between the different member ID's. currently i have a formula to calculate the days in between the date above it (which is the formula in the same workbook). I want to calculate the number of days by individual member ID.
Question 2. on the same workbook, under the question 2 table. Is there anyway to filter out the member ID and only keep the member ID with 2 or more day of service from dates? the formula would get rid of member id 1234 and member id 123456 but keep 12345 since it has more than 1 date in the service from date