Very cute Lars-Ake! No more additions to my problem. This is it.

When you have time can you explain this in 'English'?

Thanks.

"Lars-Ã…ke Aspelin" wrote:

On Wed, 30 Jul 2008 09:21:01 -0700, Lockedhart
wrote:

Okay...need to add to it.

My spreadsheet is grouped by Member ID, is there away to copy the formula
so the range is restricted to that Member? For example,

Column A (Member ID) Column B
123 6650
123 8834
123 2331
123 6650
123 6650

456 8834
456 2231
456 2231
456 8834
456 6650

Any ideas?

Thank you.

"Gary''s Student" wrote:

In B1, put 1. In B2, enter:

=COUNTIF($A$1:A2,A2) and copy down
--
Gary''s Student - gsnu200796

Try this formula in cell C1 and copy down

=IF(A1="","",SUMPRODUCT((A$1:A1=A1)*(B$1:B1=B1)))

Ready for next additional requirement ;-)

Lars-Ã…ke