VLOOKUP the second match?

  • Thread starter Thread starter Kenneth Lam
  • Start date Start date
K

Kenneth Lam

Any way to seach for the second match?

e.g.
STUDENT_NAME MARK =RANK()
AAA 99 1
BBB 95 2
CCC 95 2
DDD 90 4

Using the RANK function will have two "2". How can I find out the
second "2", i.e. CCC ?

I have asked this before (maybe 5 years ago) but I have lost the
answer. This time I have a CD-R and I can burn it on the CD.

Thanks.
 
This is perfect for a filter, if you need a formula look at

=INDEX($A$1:$A$6,SMALL(IF($C$2:$C$6=2,ROW($C$2:$C$6)),ROW()-ROW($C$2)+1))

entered with ctrl + shift & enter

note that index have to start in row 1 or else you have to offset depending
on the row where your data starts




--
For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom
 
Thanks very much!!!

This is perfect for a filter, if you need a formula look at

=INDEX($A$1:$A$6,SMALL(IF($C$2:$C$6=2,ROW($C$2:$C$6)),ROW()-ROW($C$2)+1))

entered with ctrl + shift & enter

note that index have to start in row 1 or else you have to offset depending
on the row where your data starts
Click to expand...
 
Back
Top