LinkBack URL
About LinkBacks
Entered as an array shft ctrl enter
=IF(ISERROR(SMALL(IF($B$1:$B$10=$A$1,ROW($B$1:$B$10),""),ROW(A1))),"",OFFSET($C$1,SMALL(IF($B$1:$B$10=$A$1,ROW($B$1:$B$10),""),ROW(A1))-1,0))
regards
Dav
Entered as an array shft ctrl enter
=IF(ISERROR(SMALL(IF($B$1:$B$10=$A$1,ROW($B$1:$B$10),""),ROW(A1))),"",OFFSET($C$1,SMALL(IF($B$1:$B$10=$A$1,ROW($B$1:$B$10),""),ROW(A1))-1,0))
regards
Dav
Thanks for both responses. But....
B col C Col
A PETER
B MARK
C LEWIS
D JOHN
E RAPHAEL
F SARAH
G JUNE
H TANIA
B KEVIN
J SUZIE
DAV
Your formula show "MARK" as a result it should show "KEVIN".
CARIM
I cannot download zip files on my work PC.
I've put B into A1, while my formula in A2 gives "MARK", A3 will need to show KEVIN
Last edited by DKerr; 02-01-2007 at 08:26 AM.
Hi,
Do you want me to email you the zipped file ...?
No need, I guess I can download it at home. Thanks
I gave you a response for the first answer so for the mark, if you copy it down to the rows below it will give kevin and then blanks. The formual was to replace the vlookup for the first match as well
Regards
Dav
My mistake, works perfectly, thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks