Listing by category
Al,
Yes. Select your table, then choose Data / Pivot table, and click finish. Then drag classification
to the row area, and then name to the row area, and you will get a list of names by classification.
HTH,
Bernie
MS Excel MVP
"alwein" wrote in message
...
I have a file that contains, among other things, names and "classification"
(roughly equal to occupation ala Attorney, Accountant, etc.). I want to
create a list that shows names within classification ala Accountant then
Adams, Jones, Smith, then Attorney then Boswell, Harrison, etc. It seems
there should be a way to do this other than manually. Is there?
TIA,
--
Al the Computer Pal
|