Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
compare 2 columns of numbers and place the matched numbers in a 3r
Hi.
I am a newcomer and I need your help. I need a formula that can compare a column of numbers (Column A) "LabMaster" with a 2nd column of numbers (Column C) "ScanFiles" and copy each matched number to Column B, adjacent to its match in Column A "Labmaster. (Possibly 4,000 numbers in "Labmaster". Thanks Clive |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
compare 2 columns of numbers and place the matched numbers in a 3r
Maybe this...
=IF(COUNTIF(C:C,A2),A2,"") Copy down as needed -- Biff Microsoft Excel MVP "Clive" wrote in message ... Hi. I am a newcomer and I need your help. I need a formula that can compare a column of numbers (Column A) "LabMaster" with a 2nd column of numbers (Column C) "ScanFiles" and copy each matched number to Column B, adjacent to its match in Column A "Labmaster. (Possibly 4,000 numbers in "Labmaster". Thanks Clive |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
compare 2 columns of numbers and place the matched numbers in a 3r
In cell B2
=IF(COUNTIF(C:C,A2),A2,"") If this post helps click Yes --------------- Jacob Skaria "Clive" wrote: Hi. I am a newcomer and I need your help. I need a formula that can compare a column of numbers (Column A) "LabMaster" with a 2nd column of numbers (Column C) "ScanFiles" and copy each matched number to Column B, adjacent to its match in Column A "Labmaster. (Possibly 4,000 numbers in "Labmaster". Thanks Clive |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
compare 2 columns of numbers and place the matched numbers in
Jacob you are truly fantastic!!!
Thank you so very much! I am a very happy man! Clive "Jacob Skaria" wrote: In cell B2 =IF(COUNTIF(C:C,A2),A2,"") If this post helps click Yes --------------- Jacob Skaria "Clive" wrote: Hi. I am a newcomer and I need your help. I need a formula that can compare a column of numbers (Column A) "LabMaster" with a 2nd column of numbers (Column C) "ScanFiles" and copy each matched number to Column B, adjacent to its match in Column A "Labmaster. (Possibly 4,000 numbers in "Labmaster". Thanks Clive |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
compare 2 columns of numbers and place the matched numbers in
Is it possible to add to this formula?
At the moment, when executed, it leaves empty unmatched cells in column B - a large number. Can the formula be extended to: if cell in column B is empty, delete row? Thanks again Clive "Jacob Skaria" wrote: In cell B2 =IF(COUNTIF(C:C,A2),A2,"") If this post helps click Yes --------------- Jacob Skaria "Clive" wrote: Hi. I am a newcomer and I need your help. I need a formula that can compare a column of numbers (Column A) "LabMaster" with a 2nd column of numbers (Column C) "ScanFiles" and copy each matched number to Column B, adjacent to its match in Column A "Labmaster. (Possibly 4,000 numbers in "Labmaster". Thanks Clive |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
compare 2 columns of numbers and place the matched numbers in
Sorry, you cannot do any deletions using formulas. You will need to use
amacro to do this... If this post helps click Yes --------------- Jacob Skaria "Clive" wrote: Is it possible to add to this formula? At the moment, when executed, it leaves empty unmatched cells in column B - a large number. Can the formula be extended to: if cell in column B is empty, delete row? Thanks again Clive "Jacob Skaria" wrote: In cell B2 =IF(COUNTIF(C:C,A2),A2,"") If this post helps click Yes --------------- Jacob Skaria "Clive" wrote: Hi. I am a newcomer and I need your help. I need a formula that can compare a column of numbers (Column A) "LabMaster" with a 2nd column of numbers (Column C) "ScanFiles" and copy each matched number to Column B, adjacent to its match in Column A "Labmaster. (Possibly 4,000 numbers in "Labmaster". Thanks Clive |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compare columns of numbers | Excel Worksheet Functions | |||
Formula to compare numbers in 3 columns 3/23/08 | Excel Discussion (Misc queries) | |||
Formula to compare numbers in 3 columns | Excel Discussion (Misc queries) | |||
How do I compare tow columns of numbers? | Excel Discussion (Misc queries) | |||
Compare text/numbers in different columns. | Excel Discussion (Misc queries) |