list 1 of everything in a list

[Guest]

I have a list of data in a spread sheet that results from a database query.
From this list of data, I want to be able to make a new sheet that will list
the different "categories" in the source table.
In other words, I have 459 records represented. Those records are divided
into categories. I want each category that is represented in the 459 records
listed once in a new sheet. If "hubcaps" are listed 112 of the 459 times, I
want it mentioned once in the new sheet. Likewise if "PBJ sandwiches" are
listed once in the 459 records, I want it mentioned once in the new sheet.

Hope that made sense.
TIA

 

[Debra Dalgleish]

You can use an Advanced Filter to extract a list of unique values from a
column. There are instructions in Excel's help, and here:

http://www.contextures.com/xladvfilter01.html

For the List range, select only the column that contains the categories.

 

[Paul Corrado]

Select the range with the categories and use

Data/Filter/Advanced Filter

Select a blank area in the worksheet for "Copy to new location" and select
the "Unique Records Only Option"

 

[David McRitchie]

Hi Papa Jonah ,
Not knowing what the actually purpose is going to be, it might be
worth a mention that a ivot Table could be of interest. You would
get 1 row per item type, and you would get a totals for items and
categories. Since Debra answered your question might as well
point to her page on Pivot Tables look in her excel tips index
http://www.contextures.com
The biggest problem with Pivot Tables is that you essentially have
to start over to update a Pivot Table.

 

[Guest]

Can this be done where I do not know what the categories are? I don't see
how. Right now, I could do an autofilter, but I would have to look at each
listing individually to find out the number of entries for each one in order
to fill out my table for the next series of calculations.

 

[Paul Corrado]

Yes

Can this be done where I do not know what the categories are? I don't see
how. Right now, I could do an autofilter, but I would have to look at each
listing individually to find out the number of entries for each one in order
to fill out my table for the next series of calculations.