Compare 2 columns find missing data

**dalerdd** · 01-04-2013, 03:17 PM

I want to compare two columns and paste the info from Column E that is missing from Column A into Column B.
I tried VLookup but still new at functions, and scripts. Also not sure if it is better to use function or script?Attached is a file
Thanks
Dale

**dilipandey** · 01-04-2013, 03:23 PM

Hi Dale,

Use below formula:-

Formula:

Please Login or Register  to view this content.

see attached:-
findMissing.xlsm

Regards,
DILIPandey
<click on below * if this helps>

**dalerdd** · 01-04-2013, 05:56 PM

Hi
I do not think I have this working properly I am getting results that are the same on both columns.
Attached is the excel
Thanks
Dale

**AB33** · 01-04-2013, 06:43 PM

As an option

Please Login or Register  to view this content.

**dilipandey** · 01-05-2013, 05:00 AM

I do not think I have this working properly I am getting results that are the same on both columns.

Issue is you have one extra space in your data.. check cell a1

Regards,
DILIPandey
<click on below * if this helps>

**dalerdd** · 01-05-2013, 10:49 AM

That worked great! Thank You
Dale

Compare 2 columns find missing data

LinkBack

Thread Tools

Rate This Thread

Display

Compare 2 columns find missing data

Re: Compare 2 columns find missing data

Re: Compare 2 columns find missing data

Re: Compare 2 columns find missing data

Re: Compare 2 columns find missing data

Re: Compare 2 columns find missing data

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions