View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Bernie Deitrick Bernie Deitrick is offline
external usenet poster
 
Posts: 5,441
Default 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