| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Comparing 2 columns if they are the same
I have two columns to compare. I first sort them out in the same order and
then use the IF function. The If function is OK but when the rows to compare are not match due to the error in typing or spaces then there is no match. Is there another way or function to use that instead of sorting, it will just lookup the two columns and compare and then indicate that there are say 5 mismatched and indicate them? Appreciate any help JSSU0611220 JSSU0611220 JSSU0618924 JSSU0611339 JSSU0617893 JSSU0612227 JSSU0615170 JSSU 0614195 JSSU0614370 JSSU0614322 JSSU0614322 JSSU0614370 JSSU0614195 JSSU0615170 JSSU0612227 JSSU0617893 JSSU0611339 JSSU0618924 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| comparing columns | Excel Discussion (Misc queries) | |||
| Hiding columns and custom views problem | Excel Discussion (Misc queries) | |||
| Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | Excel Discussion (Misc queries) | |||
| Need help with lookup and comparing values | Excel Worksheet Functions | |||
| Counting the Contents of Two Columns | Excel Discussion (Misc queries) | |||
Threaded Mode
