Lookup Help

[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

 

[...Patrick]

hi,

it is possible with a elaborated filter !!!

--
....Patrick
Quoi que vous fassiez, faites le bien .
Mail: http://cerbermail.com/?KPW0tTCjFw
Connectez vous sur ce forum par :
news://msnews.microsoft.com/microsoft.public.fr.excel

 

[Jamie]

thanks for the response

I still cant get it to work though

 

[Domenic]

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!

 

[Jamie]

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

 

[Domenic]

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

 

[Jamie]

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.


.