Comparing/Matching Two Sets of Data

**greaseebogus** · 10-30-2015, 12:17 AM

Hi,

I have a list of numerical data in one column.

This same data has been manually entered into a grid of approximately 10 columns at various row heights that do not correspond to row heights of the numerical data in the singular column.

What I am trying to do is to compare/match each one of the values in the singular column to its pair in the grid.

I understand I can sum each set of data, but when this does not equate, I want to be able to see which piece of data is incorrect or not matching.

Thanks in advance.

**MarvinP** · 10-30-2015, 12:42 AM

Hi greaseebogus,

This might be a place to use a helper column that has a CountIF() function in it to see what matches between column A and your range. I've created a test workbook to show what I mean. I've also used some Conditional Formatting to show what matches between the single column and the multi column ranges. Look at the helper column formula and also the CF formulas to see what I did.

BTW - I've use Random numbers for the range and column so pressing F9 might select new numbers. See the attached.

Comparing/Matching Two Sets of Data

LinkBack

Thread Tools

Rate This Thread

Display

Comparing/Matching Two Sets of Data

Re: Comparing/Matching Two Sets of Data

Thread Information

Users Browsing this Thread

Similar Threads

Comparing 2 sets of data

Comparing 2 columns that have similar matching data, need to extract the matching data

Comparing two sets of data

Comparing two sets of data

Comparing 2 Sets of Data

Comparing two sets of data

Comparing two sets of data

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions