skarnik01
Member
Hello guyz,
I have a query with regards to getting a formula / function to calculate count of rows upto last matching date and also count of rows to next last row of matching dates
Attaching an excel with some coloring for easy understanding.
In the attached example, on Row 2, Date2 has date as 6-Sep-18. So I require to have a formula / function in cell C2 which calculates value as 3 to reach upto last row of Date2 with value as 6-Sep-18.
Similarly, D2 should calculate value as 7 basis the number of rows count required to reach last row of Date2 with value as 12-Sep-18.....and so on.
I have more than 2000 rows in my excel and thereby it will be difficult to perform this task manually.
Thank you in advance and Happy New Year to all
I have a query with regards to getting a formula / function to calculate count of rows upto last matching date and also count of rows to next last row of matching dates
Attaching an excel with some coloring for easy understanding.
In the attached example, on Row 2, Date2 has date as 6-Sep-18. So I require to have a formula / function in cell C2 which calculates value as 3 to reach upto last row of Date2 with value as 6-Sep-18.
Similarly, D2 should calculate value as 7 basis the number of rows count required to reach last row of Date2 with value as 12-Sep-18.....and so on.
I have more than 2000 rows in my excel and thereby it will be difficult to perform this task manually.
Thank you in advance and Happy New Year to all