Please I need your help
I have many companies with their Distributors in excel sheet and I want to add rank for first five rows per company.
Ex:
Company Name Distributor name Rank
3M Company Arrow Electronics, Inc. 1
3M Company Avnet, Inc. 2
3M Company Digi-Key Electronics 3
3M Company TTI, Inc. 4
3M Company Newark Electronics 5
3M Company Heilind Electronics, Inc
3M Company Master International Corp.
3M Company Powell Electronics, Inc.
Ex:
Company Name Distributor name Rank
Aavid Thermalloy, LLC Heilind Electronics, Inc 1
Aavid Thermalloy, LLC Sager Electronics 2
Aavid Thermalloy, LLC Projections Unlimited, Inc. 3
Please check attached sample.
Hi Ehab
In cell C2 enter =IF(COUNTIFS($A$2:A2,A2)>5,"",COUNTIFS($A$2:A2,A2))
Copy down as required.
Hope this helps.
Sunny
Hi SunnyKow,
It is ok, many thanks.
Thanks;
Ehab
Nice and elegant Sunny, as always!
Frans
