Thread: how to i pivot a table using various criteria
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Emmal
 
Posts: n/a
Default how to i pivot a table using various criteria
i want to create a pitvot table using various criteria. this is for a
diversity report.
eg

gender salary age
male female <25 26-30 31 <21 22-30 30
1 1 1
1 1 1

how can i create a table that shows me (eg) all <21 year old males earning
over 31K
Reply With QuoteReply With Quote