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


1 reply

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