|
Counting repeatation
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 |
Counting repeatation
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 |
| All times are GMT +1. The time now is 07:19 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com