| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
COMPARE 2 COLUMNS
In C1 enter:
=IF(A1=B1,"",B1) and copy down -- Gary''s Student "CB" wrote: Hi, I would like to compare Column A with Column B. Column A is my standard and the values in column B should equal Column A. If column B is different I would like to put the Column B value in Another Column in the same row. Can you help me with this. Thanks Chris |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Formula or tool to compare two columns of data | Excel Worksheet Functions | |||
| Compare multiple column of data and list out common and unique component in adj columns | Excel Worksheet Functions | |||
| compare 2 columns | Excel Worksheet Functions | |||
| Compare 2 columns, and create a list of items that are in both lists | Excel Worksheet Functions | |||
Linear Mode
