Lookup Help

  • Thread starter Thread starter Jamie
  • Start date Start date
J

Jamie

Hi there

In A1:A24 I have a list of players, lets say Player1,
Player2, Player3....Player24.

In B1:B6 I have randomly selected values from A1:A24 so I
might have b1=Player5, b2=Player3, b3=player18 etc.

I am trying to create a copy of the list in A1:A24 that
doesn't include the values in b1:b6.

Is there an easy way of doing this. I have tried using
lookup function but I haven't had much luck. I will keep
trying but if anyone can suggest an easy way of doing this
in the meantime I would greatly appreciate it.

Thanks in advance

Jamie
 
C1, copied down:

=INDEX($A$1:$A$24,SMALL(IF(COUNTIF($B$1:$B$6,$A$1:$A$24)=0,ROW($A$1:$A$24
)),ROW(1:1)))

Hope this helps!
 
Hi there ..

Thanks for trying to help

for some reason that didn't work. In C1 was "Player 1"
then in C2:C24 there was #NUM!

I'm afraid I have no idea what this formular does so I'm a
bit puzzled trying to work it out.

Have I done something wrong?

Jamie
 
Sorry Jamie! My fault. I forgot to mention that the formula should be
entered using CONTROL+SHIFT+ENTER, not just ENTER.
 
Brilliant

Works a treat

Thanks a lot for that
-----Original Message-----
Sorry Jamie! My fault. I forgot to mention that the formula should be
entered using CONTROL+SHIFT+ENTER, not just ENTER.


.
Click to expand...
 
Back
Top