| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Stuck on combining two lists with different column headers
You could try using the COUNTIF function for each entry in the two lists to see which occur in the other list (i.e. having a count of 1). These could then the sorted to get the common entries into a block. You could then use a VLOOKUP function to bring together the two sets of data. Alternatively, if you have absolutely no duplication within each, you could get away with sorting each list's common entries by username and then just line up the other two columns. -- mrice Research Scientist with many years of spreadsheet development experience ------------------------------------------------------------------------ mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931 View this thread: http://www.excelforum.com/showthread...hreadid=568817 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing the Column Headers back to letters from #s | Excel Discussion (Misc queries) | |||
| Sorting by Column Headers | Excel Discussion (Misc queries) | |||
| Combining multiple lists into one ! | Excel Worksheet Functions | |||
| creating a bar graph | Excel Discussion (Misc queries) | |||
| Combining mutiple columns into one column | Excel Worksheet Functions | |||
Hybrid Mode
