Hi,
I need a combination of workshetfunctions witch gives me the index of the look-alike (exact match)...?
Example:
can this be done....?
Glad to have made the list
It's not an answer for you yet, but another question. What would be the case if there were a thrird kaak, or will there never be?
RegardsNick HodgeMicrosoft MVP, Excel Southampton, UK
Nick,
There will never be a third kaak...........
p.s. you don't know what kinda list it is.....
I'm on it too; should I be glad or scared?
=MIN(IF(($A$1:$A$8=A1)*(ROW($A$1:$A$8)<>ROW(A1)),ROW($A$1:$A$8)))
Regards
Bob
I was working on the 'no such thing as bad publicity' type of list.
Hope Bob's formula gives you what you want?
considering your answer is correct you have nothing to fear Bob
I owe you one
thnx (both)