View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
yhoy yhoy is offline
external usenet poster
 
Posts: 27
Default Sort by multiple fields

i have fields A, B and Value C. For each A there are multiple B. Goal is to
filter out the Maximum C for each combination of A and B. What I did:
- create a pivot table with A and B as ROW field
- drop C as data item

how to set up thus the maximum C always shows up on first line of the A&B
combination?