Consolidating a databse???

  • Thread starter Thread starter AM
  • Start date Start date
A

AM

I am using Windows NT (2000, I think) and Excel 2000.
I have a very large database, comprised of about 22 pages allo
containing zipcodes, counties, states. I am trying to figure out how to
create a list of these counties (with respective states) separate from
the database, that only lists each county/state once. As of now, the
database lists these each time a different zip code is represented.
I want a list that only names these counties/ states once (rather than
the 300 times now.) This will be printed, and referenced.
I sure hope that's clear enough...

***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****
 
Back
Top