| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
comparing two columns
I need to compare cells 2 columns and return a value if different.
e.g. A1: 2002 B:2002 A2: 2002 B:2003 A3: 2002 B:2002 Need to identify row 2 is different (with an x and a color?) I have about 1000 rows to compare. I tried some of the formulas listed in this section e.g. =if(countif(a:a,a25)1,a25,"") but didn't return what i wanted. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Comparing 3 Columns | Excel Worksheet Functions | |||
| comparing columns | New Users to Excel | |||
| Comparing two columns of information with 2 new columns of informa | Excel Discussion (Misc queries) | |||
| comparing columns | Excel Worksheet Functions | |||
| Comparing 2 columns if they are the same | Excel Worksheet Functions | |||
Threaded Mode
