Consolidate names

[mrkris1982]

If I have a bunch of names in column A and many of them are listed more than once, how can I consolidate the list to only show 1 occurence for each name that is listed?

Ive seen this before and I think it puts + signs to the left of the cells to create an expandable list, but cannot remember how to do it.

Thanks

 

[SuperFerret]

Would a Pivot Table work?

Insert > Pivot Table

Drag the names into the Row Fields section

 

[JackDanIce]

In Excel 2003:

• Select the rows you want to group,
• Select Data (from menu bar at top), then Group and Outline, then Group

 

[SuperFerret]

Followin' me again Jack?

 

[JackDanIce]

Only if you have loose morals and no inhibitions!

 

[mrkris1982]

what about Excel 2010?

I tried the same thing in it, but nothing consolidates

 

[JackDanIce]

Haven't used 2010 yet and only have 2003 at work. Have 2007 at home, I'd suspect 2010 is similar but not sure of the top of my head how. Have you tried to search your answer, say via Google?

 

[mrkris1982]

It seems like SUBTOTAL seems to work well in 2010.

Select the text, Data, Subtotal and just click ok. Then you can expand and collapse.

 

[Haldoug]

You need to sort before you group or subtotal, other wise a new group or subtotal will occur each time the name changes.

If you want a list with each of the names list just once, try the advance filter copying the results to a new location and marking the box unique records only.

 

[SuperFerret]

Only if you have loose morals and no inhibitions!

but of course