LARGE function with IF
I'm trying to create a formula to show the "Nth" highest value for a set of data but only if it meets a certain condition.
The values (to be used for the LARGE function) are either WON or PENDING. I would like to create a formula that indicates the "Nth" highest value but only look at the valies that are "PENDING".
Thanks
Answers
-
Hi @Leigh Hayman
Hope you are fine, Please add a copy of your sheet or a screenshot (after removing or replacing any sensitive information). This will make it easier for me to provide the appropriate answer to your question.
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
Thank you - the sheet is quite large and has a lot of columns so I have attached a screen shot of the relevent data.
I am trying to extract the LARGE value for Pending entries
I hope this helps
-
Try incorporating a COLLECT function.
=LARGE(COLLECT({range to collect}, {status range}, "@cell = "Pending"), n)
-
Perfect
Thanks Paul
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!