This maybe something really basic, but i can't seem to figure out how to
achieve this. (please look at the screenshot example below)

http://img91.imageshack.us/img91/6049/example014an.jpg

Looking at this picture, i want to be able to look through the 'names'
and then merge any duplicate enteries and put them on the smaller table
on the right.

However, the snag is, that i could potentially have hundreds of names,
therefore i can't simply point to them. How would i be able to tell
Excel to check Column A to see any duplicates and then merge the values
in Column B to show in the correct row in Column E.


--
PhilK
------------------------------------------------------------------------
PhilK's Profile: http://www.excelforum.com/member.php...o&userid=34665
View this thread: http://www.excelforum.com/showthread...hreadid=545093