sivaprakasam
Member
Hi
I have try to the formula in difference sheet with "summary" sheet
1st sort with condition column for "Distinct Count of Reservation" & "Distinct Count No.of Open Reservation"
formula is correct but that formula apply to 200000 rows, excel is slow very.
kindly provide alternative solution for fast calculation
I have try to the formula in difference sheet with "summary" sheet
1st sort with condition column for "Distinct Count of Reservation" & "Distinct Count No.of Open Reservation"
formula is correct but that formula apply to 200000 rows, excel is slow very.
kindly provide alternative solution for fast calculation
Attachments

16 KB Views: 12