Posted to microsoft.public.excel.misc
|
|
crossreferencing duplicate entries
=AND(COUNTIF($B$2:$B$11,B2)1,COUNTIF($C$2:$C$11,C 2)1)
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email
"Zach Gold" wrote in message
...
Thanks, that is very helpful.
It says I can use conditional formatting with the formula
=COUNTIF($B$2:$B$11,B2)1 to highlight duplicates in one category.
This is probably incredibly simple, but how do I modify the formula so it
only highlights if they match in two categories? Thanks.
Zach
"Bernard Liengme" wrote:
Visit Chip's site at www.cpearson.com
He has lots on duplicates
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email
"Zach Gold" <Zach wrote in message
...
Hi,
Haven't used Excel much, so I'm trying to find out how to do something
that
I imagine is very simple.
I have a list of addresses and I want to filter it so I get only
entries
that have two categories that exactly match another entry (for instance
last
name and zip code) so that I can delete duplicate addresses.
Any ideas how I would go about doing something like this? Any help
would
be
appreciated. Thanks!
-Zach
|