Comparing 2 columns extracting different cells

Closed
rockwell1952 Posts 1 Registration date Monday March 24, 2014 Status Member Last seen March 24, 2014 - Mar 24, 2014 at 09:11 AM
DeeNGee Posts 1 Registration date Monday March 24, 2014 Status Member Last seen March 24, 2014 - Mar 24, 2014 at 01:27 PM
Hello,


I have 2 columns of data in Column A and Column B, I want to compare these columns and the numbers in column B that are not in Column A to show up in Column C.

I am looking for a formula not a using a macro, thanks


Related:

1 response

DeeNGee Posts 1 Registration date Monday March 24, 2014 Status Member Last seen March 24, 2014
Mar 24, 2014 at 01:27 PM
I need the same answer, except I need my results to show on a new sheet. AND one of the columns goes to Row 87,007 and will increase weekly, so I need to capture the entire column without defining the rows. I will accept a macro if it's specific.
0