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