| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Compare columns of numbers
I am trying to compare 2 columns of numbers so that I can identify and
delete numbers no longer required. Can anyone help me find a formula for this please? Many thanks DT |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Compare columns of numbers
And when the 2 columns are compared what are the criteria for deciding which
numbers aren't required any more? "Dave T" wrote: I am trying to compare 2 columns of numbers so that I can identify and delete numbers no longer required. Can anyone help me find a formula for this please? Many thanks DT |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Compare columns of numbers
Assuming you want to compare col A and col B
try this in col C1 =COUNTIF($A$1:$A$10,B1) data that appear in both col will show 1, otherwise a 0 will be shows -- Hope this is helpful Pls click the Yes button below if this post provide answer you have asked Thank You cheers, francis Am not a greek but an ordinary user trying to assist another "Dave T" wrote: I am trying to compare 2 columns of numbers so that I can identify and delete numbers no longer required. Can anyone help me find a formula for this please? Many thanks DT |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 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) | |||
| How do I compare two Excel columns of numbers and see non-matches | Excel Worksheet Functions | |||
Linear Mode
