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