Hi

This can be achieved with Advanced Filter, extracting all the data to
another sheet. Make the Client name get picked up to a single cell somewhere
at the top of your sheet, and then hide the column that contains customer name.

For lots of help on Advanced Filter take a look at
http://www.contextures.com/xladvfilter01.html#ExtractWs

Regards

Roger Govier


swimmingdogz wrote:
I have a daily print log w/ 6 columns that record: date, client name,
printer's initials and three columns pertaining to sheet size. This is
working well on a daily basis as the number of sheets in a particular size
are continuously added as the month and list go on.
At the end of the month I need to consolidate the list in order to bill the
clients. Some of the clients names (print orders) will show up numerous
times. Some names are new clients, etc..

Question is: Besides using filters on the same sheet, how can I make a
consolidated list that will show the clients name only once, along with a
single sum representing the amount of sheets printed in a particular size.
How can I get excel to recognize text entries that match other entries, so
that in the end it will only list that particular name once.