Unique Record?

[Guest]

Hi..I have a list that sorts my calculated data into groups. These group sizes can change from month to month. I would like (if possible) to only show one instance from the group for printing purposes. My output looks like

Mike 24 Re
Dave 26 Re

Bill 32 Gree
Ben 43 Gree
Rog 21 Gree

Andy 26 Blu
et

It would obviously look much tidier if only one group instance could be shown and I obviously just delete the extra instances at the moment. Is there a way to automate this?

 

[Frank Kabel]

Hi
not quite sure how your expected result should look like. You may post
your result based on the example from your original post

 

[Debra Dalgleish]

To summarize your data, and show the total for each colour group, you
could use a pivot table. There are instructions and links here:

http://www.peltiertech.com/Excel/Pivots/pivotstart.htm

When you create the pivot table, add Colour to the Row area, and
Quantity to the data area, where it will become Sum of Colour.

 

[Guest]

I do not think a pivot table will give the desired result. I wish to print my output and put it on a notice board. The output would hopefully look like:

Red

Andy 11
George 24
Bill 20

Green

Mark 10
Dave 34

Blue

Fred 12
pete 23

But with a lot more names: The quantitys would change so I am not sure a pivot table will do the trick?

 

[Frank Kabel]

Hi
I would try to use a pivot table:
- use the color and the name as row items
- as data use the maximum of your number column

This should do at least as you have only one entry per name

--
Regards
Frank Kabel
Frankfurt, Germany

I do not think a pivot table will give the desired result. I wish to

print my output and put it on a notice board. The output would
hopefully look like:

Red

Andy 11
George 24
Bill 20

Green

Mark 10
Dave 34

Blue

Fred 12
pete 23

But with a lot more names: The quantitys would change so I am not

sure a pivot table will do the trick?