| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I compare lists in Excel?
I have two large lists (list1 and list2) in Excel. They both have the same
columns... and the same number of rows. In list2, differences have been made to some of the rows. But not all. I want to pinpoint the rows that have been changed. So, find the rows in list2 that are different from the rows in list1. Since these differences can occur in all of the columns (say columnA - columnAB), I don't know in which column to check. Can anyone help me out? Any help is appreciated! Jazz |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| How can I merge different lists in Excel? | Excel Discussion (Misc queries) | |||
| Is there a way to compare two excel files for repetitious cells? | Excel Worksheet Functions | |||
| How do you convert embedded drop-down lists in Excel '97? | Excel Worksheet Functions | |||
| How do I compare lists and eliminate duplictates | Excel Discussion (Misc queries) | |||
Threaded Mode
