I want to compare two columns of data and in a third column have excel label whether the data is "new", or "old". I have to sort through a bunch of names, and label them as new or old. The names that start in column one are the old ones, the names that are in column 2 are a mix of old and new, and I would like to put a label next to each in column three stating whether they are old or new. Here's a brief example of what I'd like to do:
Any tips on where to start?PHP Code:Andy James "New"
Eric Andy "Old"
Tim Matt "New"
Blake Eric "Old"
Craig Tim "Old"
Blake "Old"
Craig "Old"
Your example doesn't make sense to me...
I see Andy in both columns and Eric in both columns, yet Andy is "New" and Eric is "Old".
How exactly is the comparison supposed to work? Are you checking column A against column B or vice-versa?
Please elaborate.
Microsoft MVP - Excel
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Preferred Charities: Lupus Canada and Sick Kids Foundation.
Feel Free to Donate if you want to, for the assistance you received today.
Should the 4th column be the result D1: =IF(C1="New",B1,A1)
Otherwise, I think there is a rule missing. What should be calculated?
//Ola
Hi
=IF(ISERROR(MATCH(B1,A$1:A$100,FALSE)),"New","Old")
Alter ranges as appropriate
Rgds
I think I see it now.. you are comparing column B to column A
I think this formula should do it then//
=IF(isnumber(match(B1,A:A,0)),"Old","New")
copied down.
Microsoft MVP - Excel
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Preferred Charities: Lupus Canada and Sick Kids Foundation.
Feel Free to Donate if you want to, for the assistance you received today.
Cool, just tried it and it seems to work. Thanks for the help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks