Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Comparing
I have two columns of numbers column A could be up to 3500 rows. Column B
may be more or less than 3500 rows. What I'm trying to do is see if any number in columns "B" appears anywhere in Column "A", and if so we can just highlight it in both columns. Actually I would want to be able to sort by highlighted. so maybe add someway to sort by matched or unmatched. I hope this makes sense. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Comparing
In column C put...
=IF(ISNA(VLOOKUP($A1,$B:$B,1,FALSE)),"Not in B","In B") In column D put... =IF(ISNA(VLOOKUP($B1,$A:$A,1,FALSE)),"Not in A","In A") Sort on column C and/or Column D -- Hope this helps. If it does, please click the Yes button. Thanks in advance for your feedback. Gary Brown "Striker3070" wrote: I have two columns of numbers column A could be up to 3500 rows. Column B may be more or less than 3500 rows. What I'm trying to do is see if any number in columns "B" appears anywhere in Column "A", and if so we can just highlight it in both columns. Actually I would want to be able to sort by highlighted. so maybe add someway to sort by matched or unmatched. I hope this makes sense. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Comparing
this is great, but I prefer to do it in code so I can send this out and
nobody can change the formulas and mess it up. "Gary Brown" <junk_at_kinneson_dot_com wrote in message ... In column C put... =IF(ISNA(VLOOKUP($A1,$B:$B,1,FALSE)),"Not in B","In B") In column D put... =IF(ISNA(VLOOKUP($B1,$A:$A,1,FALSE)),"Not in A","In A") Sort on column C and/or Column D -- Hope this helps. If it does, please click the Yes button. Thanks in advance for your feedback. Gary Brown "Striker3070" wrote: I have two columns of numbers column A could be up to 3500 rows. Column B may be more or less than 3500 rows. What I'm trying to do is see if any number in columns "B" appears anywhere in Column "A", and if so we can just highlight it in both columns. Actually I would want to be able to sort by highlighted. so maybe add someway to sort by matched or unmatched. I hope this makes sense. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
comparing | Excel Discussion (Misc queries) | |||
comparing name | Excel Programming | |||
Comparing more than two | Excel Worksheet Functions | |||
Comparing | Excel Programming | |||
Comparing | Excel Programming |