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

I don't understand what you mean by merge, but if you select the names only
including the header, that would be A1:A7 using your example, then do
datafilteradvanced filter, make sure you onlyt use A1:A7 as the range, then
select copy to another location, select D1 as the other location, select
unique records only and click finish. That will give you the names, then in
the first adjacent cell to the first name which would be E2, put this formula
there

=SUMIF($A$2:$A$7,D2,$B$2:$B$7)

copy down as long as needed


Regards,

Peo Sjoblom


"PhilK" wrote:


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

Okay thats getting very close to what i want.

However. The table on the right hand side, won't have anything filled
in. The information comes from the table on the left. The table on the
right effectively summarises the info taken on the left.

Therefore, the names on the table on the right cannot be fixed. They
have to be taken from the table as well.


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

If you want the list to be dynamic you can use a formula


http://nwexcelsolutions.com/Download..._records. xls


you can download an example of this, look at the the distinct list formulas


Regards,

Peo Sjoblom


"PhilK" wrote:


Okay thats getting very close to what i want.

However. The table on the right hand side, won't have anything filled
in. The information comes from the table on the left. The table on the
right effectively summarises the info taken on the left.

Therefore, the names on the table on the right cannot be fixed. They
have to be taken from the table as well.


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