Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Compare List and Show Mismatched
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 -- Phillycheese5 ------------------------------------------------------------------------ Phillycheese5's Profile: http://www.excelforum.com/member.php...o&userid=24196 View this thread: http://www.excelforum.com/showthread...hreadid=381236 |
#2
|
|||
|
|||
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 -- greg7468 ------------------------------------------------------------------------ greg7468's Profile: http://www.excelforum.com/member.php...fo&userid=9031 View this thread: http://www.excelforum.com/showthread...hreadid=381236 |
#3
|
|||
|
|||
Greg, thanks for the help...I'll give it a try -- Phillycheese5 ------------------------------------------------------------------------ Phillycheese5's Profile: http://www.excelforum.com/member.php...o&userid=24196 View this thread: http://www.excelforum.com/showthread...hreadid=381236 |
#4
|
|||
|
|||
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. -- MrShorty ------------------------------------------------------------------------ MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181 View this thread: http://www.excelforum.com/showthread...hreadid=381236 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
The 'Recently used file list' does not show up under the 'File' menu. | Excel Worksheet Functions | |||
HOW DO I SUMMARIZE A LIST OF TEXT, I WANT ONE A TO SHOW UP NOT 10 | Excel Worksheet Functions | |||
Show comma in data validation list? | Excel Discussion (Misc queries) | |||
On my data menu, my list command does not show | Excel Discussion (Misc queries) | |||
Excel Auto Filter: WHY'S SORT @ TOP OF LIST? WHEN I KEY TO "SHOW . | Excel Worksheet Functions |