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.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!