Find second highestsalesprice
welcome
On 25 Lut, 17:26, "Jan Kronsell"
wrote:
Thank you all. I used the solution from Ashish as that was the shortest.
Jan
wrote:
I have a spreadsheet:
Price * *Status
100
120 * * * Sold
115 * * * Sold
130
140 * * * Sold
Now I try to find the seocnd larges amout *something is sold for. I
have tried something like
=SUMPRODUCT((B2:B6="Sold")*(A2:A6=LARGE(A2:A6;2))* (A2:A6)
or
=IF(C2:C15="solgt";LARGE(D2:D15;2))
entered as an array formula, but both (other attempts as well) returns
130 (the second highest price) where it should return120 (second
highes price, sold).
Any suggestions?
Jan- Ukryj cytowany tekst -
- Pokaż cytowany tekst -
|