Index Large - need 4 most recent dates in a series

Lauren Y

Hello - I need help listing out the 4 most recent invoice dates for each project (2 are shown below). I have a separate summary sheet that lists each project and was able to use Index(Max) to get the most recent invoice date then pull in that amount. Now I am stuck trying to get the other 3. Complexities are that I would like the most recent invoices and so I cant just look back the past 4 months, as sometimes they get missed (what I was doing in the second shot). Thinking something with Index/Collect/Large but cant quite get it to work, then tried just large with a helper column. getting stuck. any help is appreciated thanks!

Corey W.

How about this:

=LARGE(COLLECT([Invoice Date]:[Invoice Date], [Project Name]:[Project Name], "CONCEPT"), 1)

Where you change the 1 (n-th highest number) for each of your columns, 1..2..3..4

Corey W.

How about this:

=LARGE(COLLECT([Invoice Date]:[Invoice Date], [Project Name]:[Project Name], "CONCEPT"), 1)

Where you change the 1 (n-th highest number) for each of your columns, 1..2..3..4

Lauren Y

Perfect!! thank you so much for answering.