View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] jkr@knord.dk is offline
external usenet poster
 
Posts: 8
Default Find second highestsalesprice

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