| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Comparing columns
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
|
|||
|
|||
|
Comparing columns
Suppose you are comparing ColA and ColB. In Col C use the below formula
This will compare the entry in B1 aganist column A and if found return "Found" or else "Not Found" In C1 use the below formula and copy down as required. =IF(COUNTIF(A:A,B1)0,"Found","Not found") If this post helps click Yes --------------- Jacob Skaria "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 | |||
| comparing columns | New Users to Excel | |||
| Comparing Two Columns | Excel Discussion (Misc queries) | |||
| Comparing two columns of information with 2 new columns of informa | Excel Discussion (Misc queries) | |||
| Comparing Columns | Excel Worksheet Functions | |||
| comparing columns | Charts and Charting in Excel | |||
Linear Mode
