View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
re re is offline
external usenet poster
 
Posts: 2
Default Consolidate 3 lists with duplicates into one list

Hi,

How do I take 3 lists with similar but not exact information and also
compare and consolidate those lists into one list. For example:

A B A B A B
Chix 20 Lio 10 App 5
App 10 Bob 15 Lio 10
Lio 12 Chix 20 Bob 10
Chix 10

Does that make sense?

Thx, Re
--
Re