Counting repeatation

S

Sevi

Hello,

I have a worksheet as below having two colomns, the first colomn is the list
name and second one is numbers, is there any way to count the number
repeating instances in which both Name and Number are similar against the
concerned row. Please Help me

Regards, Sevi



Name Number
AAA 12.00
AAA 11.75
AAA 12.50
BBB 12.50
BBB 13.00
BBB 13.00
BBB 13.50
CCC 13.50
CCC 12.00
CCC 12.00
DDD 14.45
DDD 14.45
DDD 14.00
 
B

Biff

What kind of result do you expect?

This formula returns 3:

=SUMPRODUCT(--(A3:A14&B3:B14=A2:A13&B2:B13))

Biff
 
Top