What kind of result do you expect?

This formula returns 3:

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

Biff

"Sevi" wrote in message
...
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