counting with a criteria in multiple transactions
I want to count the number of persons who have done transactions in a
particular range where one person has done many transactions |
Try:
=SUM(1/COUNTIF(C2:C13,C2:C13)) Enter as an array formula (Ctrl/Shift/Enter) Don "shafali" wrote in message ... I want to count the number of persons who have done transactions in a particular range where one person has done many transactions |
All times are GMT +1. The time now is 07:49 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com