Look up new numbers from old list in new list
Closed
Rabbit84
-
Jul 9, 2009 at 02:42 PM
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 - Jul 11, 2009 at 10:38 PM
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 - Jul 11, 2009 at 10:38 PM
Related:
- Look up new numbers from old list in new list
- My contacts list names - Guide
- Counter strike 1.6 cheats list - Guide
- How to change your best friends list on snapchat to 3 - Guide
- Whatsapp country code list - Guide
- Amd crossfire compatibility list - Guide
4 responses
Excelguru
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
Jul 11, 2009 at 03:03 AM
Jul 11, 2009 at 03:03 AM
Hi Rabbit84
try =IF(Countif(B2:b9,"=" & e2)>0,"",e2)
try =IF(Countif(B2:b9,"=" & e2)>0,"",e2)
OMG, thank you soooo much this is what I was lookikng for. I tried the vlookup formula but that was not the best one, I mean it worked but instead of giving me the result, it have a #N/A and I had to look beside the #N/A to get the answer.
How did you find that formula? I am soo happy.
How did you find that formula? I am soo happy.
Rabbit84
Posts
1
Registration date
Friday July 10, 2009
Status
Member
Last seen
July 11, 2009
Jul 11, 2009 at 09:56 AM
Jul 11, 2009 at 09:56 AM
Sorry to bother you again, I have another question.
From the first question that i asked you, is there a way that the result can be highlighted? I guess what I am trying to say is, Jon gets a new list everyday. Everytime the a new list comes out, Jon needs to know what numbers are new, and what numbers are not on his list any more. So, I guess what I am trying to say is there anyway that his add on numbers from the new list be highlighted in Column F, and the numbers that are not on his list anymore be highlighted in column B instead of displaying it in Column C or G. I hope you get what I am talking about. Also, I'm going back to school for Office System Technial. I love thinking and anything that has to do with math, I'm all for it. What is a good career field for me. I work for one of the biggest banks in the world, and I work with a bunch of dumb smart people. I need a career change. (hope thats not to personal to ask)
A B C D E F G
Agent Old List Saves Agent New List Adds
Jon 12345 Jon 12345
Jon 12988 12988 Jon 83987 83987
Jon 12987 Jon 18749 18749
Jon 17859 17859 Jon 39283
Jon 20192 Jon 76545
Jon 39283 39283 Jon 99212
Jon 46371 46371 Jon 78685 78685
Jon 56557 56557 Jon 98274
Jon 75849 75849 Jon 20192 20192
Jon 76545 76545 Jon 11564 11564
Jon 76564 76564 Jon 8881 8881
Jon 98274 98274 Jon 11297 11297
Jon 98767 98767 Jon 12987 12987
Jon 99212 99212 Jon
From the first question that i asked you, is there a way that the result can be highlighted? I guess what I am trying to say is, Jon gets a new list everyday. Everytime the a new list comes out, Jon needs to know what numbers are new, and what numbers are not on his list any more. So, I guess what I am trying to say is there anyway that his add on numbers from the new list be highlighted in Column F, and the numbers that are not on his list anymore be highlighted in column B instead of displaying it in Column C or G. I hope you get what I am talking about. Also, I'm going back to school for Office System Technial. I love thinking and anything that has to do with math, I'm all for it. What is a good career field for me. I work for one of the biggest banks in the world, and I work with a bunch of dumb smart people. I need a career change. (hope thats not to personal to ask)
A B C D E F G
Agent Old List Saves Agent New List Adds
Jon 12345 Jon 12345
Jon 12988 12988 Jon 83987 83987
Jon 12987 Jon 18749 18749
Jon 17859 17859 Jon 39283
Jon 20192 Jon 76545
Jon 39283 39283 Jon 99212
Jon 46371 46371 Jon 78685 78685
Jon 56557 56557 Jon 98274
Jon 75849 75849 Jon 20192 20192
Jon 76545 76545 Jon 11564 11564
Jon 76564 76564 Jon 8881 8881
Jon 98274 98274 Jon 11297 11297
Jon 98767 98767 Jon 12987 12987
Jon 99212 99212 Jon
Excelguru
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
Jul 11, 2009 at 10:38 PM
Jul 11, 2009 at 10:38 PM
Hi Rabbit84
Try this for v =if (iserror(vlookup(,,,)),value,"")
for your second question , I dont know any no straight way with excel but can be done using excel VBA
Try this for v =if (iserror(vlookup(,,,)),value,"")
for your second question , I dont know any no straight way with excel but can be done using excel VBA
