counting

if i have two columns
001, apple
001, orange
001, orange
001, fish
001, fish
001, fish
002, apple
002, meat
002, meat
003, beef

how can i get the following result
001, apple, 1
001, orange, 2
001, fish, 3
002, apple, 1
002, meat, 2
003, beef, 1

You can get close by sorting the data and using data|subtotals.

You can get closer by using data|pivottable.

Select your data (A1:Cxxx) and include headers in row 1
data|pivottable
follow the wizard until you get a dialog with a Layout button on it.
click that layout button

drag the item number to the row field
drag the fruit name to the row field
drag the fruit name to the data field
and finish up.

If you double click on the grey item number and grey fruit name, you can tell
excel not to show subtotals for that field.


Win wrote:
>
> if i have two columns
> 001, apple
> 001, orange
> 001, orange
> 001, fish
> 001, fish
> 001, fish
> 002, apple
> 002, meat
> 002, meat
> 003, beef
>
> how can i get the following result
> 001, apple, 1
> 001, orange, 2
> 001, fish, 3
> 002, apple, 1
> 002, meat, 2
> 003, beef, 1

--

Dave Peterson