Jim,

What I suggested gives a table of counts of each unique item. But to do it,
you need to drop the button on BOTH the row and data areas You get the
total count if you only drop the button on the data area, and not in the row
area.

HTH,
Bernie
MS Excel MVP

"George" wrote in message
...
Bernie,

No. What you suggested just gives me a total count.

Jim


On Mon, 2 Aug 2004 15:45:08 -0400, "Bernie Deitrick" <deitbe @
consumer dot org wrote:

George,

Select your table, then use Data | Pivot Table.

Select the button with the heading for your second column to the row
area,
and then the data area, and you will get a table of counts for each
unique
value in your second column.

HTH,
Bernie
MS Excel MVP

"George" wrote in message
.. .
Hi,

I have an Excel 2000 speadsheet, which consists of a long list.
This long list has 3 columns.

2 of the colums are alpha, and the one is numeric.

The alpha column may have many duplicates, while one of the remaining
fields (the numeric one) may change for each duplicate.

So we have:

COLUMN A COLUMN B COLUMN C
1010111 ddllol df


Please note that what's in column c doesn't matter to me. It's just
there.

OK, so Column B can have duplicate entries as mentioned.

But, if Column B has any duplicates, you can be sure that the numeric
value in Column A is different.

What I need is to be able to count up how many different 'versions' or
values that any Given value in Column B has.

I know it sounds like an MS Access thing, but I'm sure one of you
bright Excel people can help with this.

Thanks in advance,
George