I have a bunch of dates in Column B. In Cell X1 I have used a formula to find the next date in the future from column B. I have used the index match formula to find the next date in the list and then to tell me what is in the cell to the left of it. However, sometimes there will be numerous equal dates as in the next date the index match is finding might be the 20th July and there might be up to 10 different instances of the 20th July in column B. How can I get the formula to return all 10 results instead of just the first one it comes across?
Bookmarks