Spreadsheet: 874427d1721025444-ranking-on-cell-value-and-getting-number-of-unique-value-navin_ranking_on_cell_value_and_getting_number_of_unique_value_
Sheet: Sheet1

 |  |  |  |  |  |  |  | Ranking
 |  |  | Industry | Name of the Instrument |  | Points
 |  |  | Banks | ICICI Bank Limited |  | 5.317609298764036
 |  |  | Petroleum Products | Reliance Industries Limited |  | 11.95
 |  |  | IT - Software | Infosys Limited |  | 6.038249617984482
 |  |  | Construction | Larsen & Toubro Limited |  | 3.5
 |  |  | Banks | HDFC Bank Limited |  | 1.316302827246384
 |  |  | Pharmaceuticals & Biotechnology | Sun Pharmaceutical Industries Limited |  | 7.297394964794989
 |  |  | Banks | Kotak Mahindra Bank Limited |  | 1.954620112495912
 |  |  | Telecom - Services | Bharti Airtel Limited |  | 1.2
 |  |  | Automobiles | Mahindra & Mahindra Limited |  | -0.1624855334977605
 |  |  | IT - Software | HCL Technologies Limited |  | 2.750776967315205
 |  |  | Finance | Shriram Finance Ltd |  | 1.092856314750844
 |  |  | Banks | State Bank of India |  | 0.7619320317317879
 |  |  | Consumer Durables | Whirlpool of India Limited |  | 3.459927330973709
 |  |  | Banks | Axis Bank Limited |  | 1.858512296291446
 |  |  | Electrical Equipment | CG Power and Industrial Solutions Limited |  | 11.925
 |  |  | Commercial Services & Supplies | CMS Info Systems Limited |  | 16.6
 |  |  | Cement & Cement Products | UltraTech [NAME] |  | 5.066367359661151
 |  |  | Auto Components | CIE Automotive India Ltd |  | 3.842475191964377
 |  |  | Auto Components | Bharat [NAME] |  | 1.564442735179573
 |  |  | Cement & Cement Products | Ambuja Cements Limited |  | 3.090718177887613
 |  |  | Beverages | Radico Khaitan Limited |  | -3.764567283383954
 |  |  | Cement & Cement Products | JK Cement Limited |  | 3.496896910910747
 |  |  | Consumer Durables | Kajaria Ceramics Limited |  | 2.947483973809905
 |  |  | Industrial Products | Happy Forgings Ltd |  | 0.4277215207242973
 |  |  | Industrial Products | AIA Engineering Limited |  | 4.452654332658803
 |  |  | Chemicals & Petrochemicals | NOCIL Limited |  | 15.575
 |  |  | Automobiles | [NAME] Limited |  | 2.450405062062714
 |  |  | Auto Components | Schaeffler India Limited |  | 0.07093465242636779
 |  |  | Healthcare Services | Apollo Hospitals Enterprise Limited |  | 12.475
 |  |  | Finance | REC Limited |  | 3.648412279461518
 |  |  | Finance | Cholamandalam Investment and Finance Company Limited |  | 1.802336024336774
 |  |  | IT - Software | Tech Mahindra Limited |  | 1.837614976273436
 |  |  | Auto Components | Sundram Fasteners Limited |  | 2.464577590991304
 |  |  | Consumer Durables | V-Guard Industries Limited |  | 1.508571921937448
 |  |  | Finance | SBFC Finance Ltd |  | -2.584227396104696
 |  |  | Finance | LIC Housing Finance Limited |  | 2.080005472447065
 |  |  | Industrial Products | WELSPUN CORP LIMITED |  | 3.798692905317637
 |  |  | Personal Products | Godrej Consumer Products Limited |  | 17.65
 |  |  | Consumer Durables | Blue Star Limited |  | 0.7728261238622688
 |  |  | Retailing | [NAME] |  | 13.6
 |  |  | Textiles & Apparels | Gokaldas Exports Ltd |  | 13
 |  |  | Power | NTPC Limited |  | 3.35
 |  |  | Pharmaceuticals & Biotechnology | Ajanta Pharmaceuticals Limited |  | -1.913379824675796
 |  |  | Beverages | United Spirits Limited |  | 7.445318294824895
 |  |  | Gas | Gujarat Gas Limited |  | 13.75
 |  |  | Banks | AU Small Finance Bank Limited |  | -0.5178969542857617
 |  |  | Pharmaceuticals & Biotechnology | Cipla Limited |  | 1.089560316626094
 |  |  | Consumer Durables | Cello World Ltd |  | 1.238750270551569
 |  |  | IT - Software | Persistent Systems Ltd |  | 0.816462455913496
 |  |  | Entertainment | Zee Entertainment Enterprises Limited |  | -8.799999999999999
 |  |  | Auto Components | Craftsman Automation Ltd |  | 1.0184398331705
 |  |  | Insurance | Life Insurance Corp of India |  | 14.35
 |  |  | Food Products | Britannia Industries Limited |  | 19.4