gtd526
Well-known Member
- Joined
- Jul 30, 2013
- Messages
- 657
- Office Version
- 2019
- Platform
- Windows
Hello,
Im using the following array to find the MAX value of a Named Range (NBAGL as array), which is working.
How can I find the 2nd Largest, 3rd Largest value using this array?
{=INDIRECT(INDEX(NBAGL,MATCH(MAX(N(INDIRECT(NBAGL))),N(INDIRECT(NBAGL)),0)))}
thank you.
Im using the following array to find the MAX value of a Named Range (NBAGL as array), which is working.
How can I find the 2nd Largest, 3rd Largest value using this array?
{=INDIRECT(INDEX(NBAGL,MATCH(MAX(N(INDIRECT(NBAGL))),N(INDIRECT(NBAGL)),0)))}
thank you.