| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
MS Excel 2000 - Compare two lists of data.
.. and was unsuccessful -a lot of false "True" ..
You're probably hit by data inconsistency, either text nums vs real nums issue and/or extraneous white spaces for textstring matches. It's quite common. Paste some representative sample data for both the lookup values and the reference col values where there are apparent matches which are not being returned correctly. -- Max Singapore http://savefile.com/projects/236895 Downloads:27,000 Files:200 Subscribers:70 xdemechanik --- |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to compare multiple lists of data in excel | Excel Discussion (Misc queries) | |||
| Compare two lists of data to find new entries | Excel Discussion (Misc queries) | |||
| compare data in two lists to find matching entries | Excel Discussion (Misc queries) | |||
| compare data in two lists to find matching entries | Excel Discussion (Misc queries) | |||
| compare data in two lists to find matching entries | Excel Discussion (Misc queries) | |||
Threaded Mode
