I have a spreadsheet like the following:


A B C D E

1 CustID Ref # Inv # Paid Inv. Date No. of
dist.
2 James Check #123 101 01/01/05 1
3 Mary Visa123 343 02/03/05 2
4 Mary Visa123 345 02/03/05 2
5 Buger /RR123 456 01/09/05 3
6 Buger /RR123 457 01/09/05 3
7 Buger /RR123 458 01/09/05 3


I need a formula or functions, or whatever that will count how many times a
check, visa or whatever ref # and put that count in the "No. of
Distributions" column. That same number has to be on each line associated
with that "reference #". I am sure there is a way. I tried the subtotal -
using the count but it doesnt total in the "no. of distributions column".

Need help ASAP!!!! Need answer 2nite - need to finished so I can sleep.
Been up since 12:45 a.m. Went to be at 10 p.m. Saturday night.

Please Please Help!!