EXCEL FILTERING - aghh!
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
|