Assistance with Index, Match, Max, Collect

Answers
-
I am trying to do the same. Here is my max collect formula in which I am using the helper column you suggested.
=MAX(COLLECT([Approved Until]:[Approved Until], Patient:Patient, @cell = Patient@row))
Now I am trying to make my Index Collect on another sheet. Here is what I have so far:
=IFERROR(INDEX(COLLECT({Auth Level}, {Date Helper Column}, Name@row, {Patient name}, 1)), "---")
I am receiving an incorrect argument error. Please assist
-
@Todd O You do not have a criteria for the {Date Range}, and your last range/criteria set is flipped around backwards.
-
Thank you Paul. Please explain what you meant by not having a criteria for {Date Rage}. This is not a component of my formula.
-
@Todd O See in bold:
=IFERROR(INDEX(COLLECT({Auth Level}, {Date Helper Column}, Name@row, {Patient name}, 1)), "---")
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!