'How do you determine a 2nd, 3rd, 4th, up to nth value in a range / How do you exclude a value from a range?
I'm looking for a way to find an nth value in a range using excel. I'm not very tech-savvy but I have a basic understanding of the formulas and how to use them. I tried
=MAX(IF(A1:A10<D1, [MAX(A1:A10-D1)])
because I thought it said "If A1:A10 is lesser than D1, use A1:A10 without the value of D1 as a range and then find the maximum of that range." but it needs a third result, [result_if_false}. I already have a way to find the MAX and the MIN but I just need help with finding an nth value or excluding a value from a range. Thank you!
A1:A10 is the range of numbers
D1 is the Highest number or the MAX of the range
D1:D10 is where I'm planning to show the ordered numbers
Solution 1:[1]
In cell D1, paste the following formula:
=LARGE($A$1:$A$10,COUNT($A$1:$A$10)-COUNT($A1:$A$10)+1)
Then copy and paste it into cells D2:D10.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | bugdrown |