| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Compare two different size lists
(I searched, but the key words yield way too many non-related hits) I have two lists, A10:B400 and C10:D300. All the sets of data in CD (a name and a number respectively) are in AB, but AB, obviously, has more sets of data than CD. Is there a function, which I can enter in E10:E400, for example, that will compare each value in A with _all_ the values in C, and if the A value is not in C, it will write the missing value(s) in E (and F), in the same row as the A 'source'? What I trying to find are the sets of data in AB that are not in CD. Please let me know if I didn't make my query clear enough... Thanks alex -- Ingeniero1 ------------------------------------------------------------------------ Ingeniero1's Profile: http://www.excelforum.com/member.php...fo&userid=4029 View this thread: http://www.excelforum.com/showthread...hreadid=466041 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I compare lists and eliminate duplictates | Excel Discussion (Misc queries) | |||
| Can I compare 2 lists to combine duplicate entries in new list? | Excel Worksheet Functions | |||
| Compare ranges different size | Excel Worksheet Functions | |||
| How can I compare two lists of data (channel lineups) - find what. | Excel Worksheet Functions | |||
| How do I compare two lists of names in excel? | Excel Discussion (Misc queries) | |||
Threaded Mode
