Good morning everybody,
I am hoping someone may be able to help write a formula to solve the following problem. I am pretty sure it is a matched index formula, but i cant seem to find one online to help me figure it out, so i am looking to one of you to provide a solution.
It is easiest to explain the formula i am after in the 2 tables below.
What i am trying to do is write a formula for column B (Start Date) and Column C (End Date) that looks up the first and last data entry for each of the companies and returns the corresponding month...
It should look like the second table of the two below.
Can anyone help?
Thanks in advance
Bookmarks