Pivot Table Help


R

RB

I have a list of customer names (customer ID, name, state, city, zip,
and address). I want to know which customers are in what states. I
tried using a pivot table but it doesn't work. I want to use the the
pivot table format i.e. list of states in the Row label and the
corresponding customers and the zip in the value label. Any ideas?
 
Ad

Advertisements

T

trip_to_tokyo

I have a list of customer names (customer ID, name, state, city, zip,
and address). I want to know which customers are in what states. I
tried using a pivot table but it doesn't work. I want to use the the
pivot table format i.e. list of states in the Row label and the
corresponding customers and the zip in the value label. Any ideas?

You don't say which version of EXCEL you are using.

In EXCEL 2007 consider using:-

Data tab.

Sort & Filter group.

Either click on the Filter button or use the Sort button depending on
your preference / what you are trying to do.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top