MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Comparing 2 columns


Posted by Quang Tran on August 23, 2001 8:54 AM

Thanks in advance for any assistance. Let's say I have 2 columns of social sec. numbers. They are all out of order. Some soc. sec. numbers are in both columns, some are not. I'd like to line these up side by side. The end result is to have the matching soc. sec. number on the same row. For unmatched numbers, just leave that cell blank.


Posted by IML on August 23, 2001 10:04 AM

If your first list in column A, and second is in E1:E10, try
=IF(COUNTIF($E$1:$E$10,A1)>0,A1,"")
and copy it down.

good luck

Posted by Quang Tran on August 23, 2001 12:23 PM

Thank you very much.