Index Large - need 4 most recent dates in a series
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!
Best Answer
-
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
Answers
-
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
-
Perfect!! thank you so much for answering.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.1K Get Help
- 444 Global Discussions
- 140 Industry Talk
- 472 Announcements
- 5K Ideas & Feature Requests
- 83 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 489 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!