Thread: SMALL and LARGE
View Single Post
  #4   Report Post  
Bob Phillips
 
Posts: n/a
Default SMALL and LARGE

=LARGE(IF(MATCH(S1:S10,S1:S10,0)=ROW(Data)-CELL("Row",S1:S10)+1,S1:S10),2)

=SMALL(IF(MATCH(S1:S10,S1:S10,0)=ROW(Data)-CELL("Row",S1:S10)+1,S1:S10),2)

array formulae, so commit with Ctrl-Shift-Enter

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Tonto" wrote in message
oups.com...

Thanks. I think I pointed that out but still need a solution.

John