| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
comparing two columns
there are two columns containing numbers and have common numbers i want to
have the uncommon numbers in a seperate column |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
comparing two columns
See if this is what you need, if something exists in colomn B that is not in
column A it will return it. put this in column C and copy down =IF(COUNTIF($A$1:$A$6,B1)=0,B1,"") -- -John Northwest11 Please rate when your question is answered to help us and others know what is helpful. "mouhammmmmmmad" wrote: there are two columns containing numbers and have common numbers i want to have the uncommon numbers in a seperate column |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Comparing columns from 2 different worksheets. | Excel Worksheet Functions | |||
| Comparing multiple columns | New Users to Excel | |||
| Comparing Columns, Then copying data | Excel Discussion (Misc queries) | |||
| Comparing stacked columns | Charts and Charting in Excel | |||
| comparing columns | Excel Discussion (Misc queries) | |||
Linear Mode
