Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how can I match numbers from two columns?
I have two large columns with numbers. I need to check what numbers from
column 2 are already in column 1. Example: 25 55 20 25 Already in column A 19 42 31 20 Already in column A That's all I need. A formula in column C that tell me what numbers from column B are already in column A. Anny suggestions? Thanks! Thanks a lot |
#2
|
|||
|
|||
Hi Lea,
Try =If(Countif($A$1:$A$100,B1)0,"Duplicate","") "Lea" wrote in message ... I have two large columns with numbers. I need to check what numbers from column 2 are already in column 1. Example: 25 55 20 25 Already in column A 19 42 31 20 Already in column A That's all I need. A formula in column C that tell me what numbers from column B are already in column A. Anny suggestions? Thanks! Thanks a lot |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to find MATCH numbers ? | Excel Worksheet Functions | |||
how can I omit the array( numbers and letters for columns and row | New Users to Excel | |||
column filtering to match identical numbers | Excel Discussion (Misc queries) | |||
making columns automatically turn numbers into negatives | Excel Worksheet Functions | |||
HOW TO MATCH MULTIPLE COLUMNS WITH OR WITHOUT GAPS IN eXCEL ? | Excel Worksheet Functions |