I know Access has solutions, but it would help my cause if I could compare 2 lists of text and show the mismatches in XL.
Any help would be great...
Phillycheese5
I know Access has solutions, but it would help my cause if I could compare 2 lists of text and show the mismatches in XL.
Any help would be great...
Phillycheese5
Hi,
assuming your first list is in A1:A100
and your second list is in B1:B100
in C1 put this formula
=IF(COUNTIF($A$1:$A$100,B1)>0,"match","")
drag this down column C
HTH
Greg.
"The most overlooked advantage of owning a computer is that if they foul up there's no law against whacking them around a bit."
Greg, thanks for the help...I'll give it a try
HEre's how I might do it. Details depend on what you want to do with matches/mismatches:
Assuming your lists are in columns A and B, in C1 place formula =A1=B1. Returns TRUE if A and B match, returns FALSE if they don't. Copy formula down column C.
To show if the lists match exactly D1=AND(C1:C10000)
To count the number of mismatches D2=COUNTIF(C1:C10000, FALSE)
You could also use Autofilter/conditional formatting to highlight and/or display the mismatches.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks