Unique Records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I was looking for someone who could help me with the following:

I have a rather large Datase (5000 records and growing). One of the data
collumns excists of 120 different categories (and still growing). How can I
make a list, in another sheet, which only contains the categories? Thanks in
Advance!
 
Data>filter>advanced filter and unique records only and copy to another
location, select only the column with
categories
 
and if it's still growing you might like to check out using data /
validation and dynamic ranges where you can add the new entries to the
copied unique list and then provide a drop down on the column in the
original data where these entries can be selected from.

check out
http://www.contextures.com/xlDataVal01.html
and
http://www.contextures.com/xlNames01.html#Dynamic

and for more info on advanced filters check out
http://www.contextures.com/xladvfilter01.html#FilterUR and
http://www.contextures.com/xladvfilter01.html#ExtractWs

Cheeers
JulieD
 
Back
Top