Hi

Your case is an excellent example when using full name in table is a wrong
solution.

When you design your table so, that instead ov 2 name columns you have
columns ForeName, Lastname, your life will be much easier. Whenever you need
to get the full name, you can have it in any form
=ForeName & " " & LastName
or
=LastName & " " & Forename
or
=LastName & ", " & Forename
etc.

Also, you always can sort your table at 1st by Forename and then by
LastName, or vice versa.


--
Arvi Laanemets
( My real mail address: arvil<attarkon.ee )


"snugs25" wrote in message
...
Hello, would be grateful if someone could help me here. I have 2 lists of
names in 2 different columns. one column has the names first and then
last,
the other has the names last and then first. Ive used a foruma provided by
someone else on this site to reverse the order which works no problem. Now
however when i try and filter the names to compare which people are on
both
lists, it doesnt return with any results, yet i know there are names which
appear on both lists. if anyone can help me i would reaaallly appriciate
it.

Thanks
Gemma