Creating list based on Values from a second column

  • Thread starter Thread starter Storm_21_924
  • Start date Start date
S

Storm_21_924

For example, Say I have a lot of coins and want to see from what Mints
I have what coins.

In Column B I have Mints
In Column C I have the coin denomination. for each each row say,
B2: Denver, C2: .25
B3: Phili, C3: .5
B3: Denver, C2: .10
etc
etc

I would like to create a unique list based on each mint.

So i would have a column for Denver, column for Phili, etc.

Each column does not have to filter out unique values.

Help!?

Thanks!
 
It sounds like a nice layout to learn about pivottables.

Add headers to row 1 (if you don't have them). I used Mints and Coin as my
headers.

Then select your range (B1:C###)
Data|Pivottable (in xl2003 menus)
Follow the wizard until you get to the step that has a Layout button on it.
Drag the Mints button to the row field.
Drag the Coin button to the header field.
Drag the coin button (again) to the data field.
If you don't see "Count of coin", then right click on it and choose Count.

And finish up the wizard.

You'll probably want to change the format to show the correct number of decimals
for the dime (.1 doesn't look as nice as .10).
 
Back
Top