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

 |  |  |  |  |  |  |  | Ranking
 |  |  | Industry | Name of the Instrument |  | Points
 |  |  | IT - Software | Infosys Limited |  | 4.440769562164561 |  |  |  | 14
 |  |  | Banks | ICICI Bank Limited |  | 4.819617475550621 |  |  |  | 11
 |  |  | Banks | HDFC Bank Limited |  | 1.470699737708617 |  |  |  | 22
 |  |  | Banks | Kotak Mahindra Bank Limited |  | 1.688197247205802 |  |  |  | 21
 |  |  | IT - Software | LTIMindtree Limited |  | 1.195514099447682 |  |  |  | 26
 |  |  | IT - Software | Tata Consultancy Services Limited |  | 0.623850125460868 |  |  |  | 33
 |  |  | Electrical Equipment | ABB India Limited |  | -0.6250000000000004 |  |  |  | 40
 |  |  | Banks | Axis Bank Limited |  | 2.020005057426894 |  |  |  | 20
 |  |  | Telecom - Services | Bharti Airtel Limited |  | 1.2 |  |  |  | 25
 |  |  | Consumer Durables | Titan Company Limited |  | -3.605075243064711 |  |  |  | 45
 |  |  | IT - Software | HCL Technologies Limited |  | 0.9993852198318889 |  |  |  | 30
 |  |  | Banks | State Bank of India |  | 0.6252980468109797 |  |  |  | 32
 |  |  | IT - Software | [NAME] |  | 0.4436866308706628 |  |  |  | 34
 |  |  | Automobiles | Mahindra & Mahindra Limited |  | -0.08771702740210545 |  |  |  | 38
 |  |  | Auto Components | Sona BLW Precision Forgings Limited |  | 7.89036560310976 |  |  |  | 6
 |  |  | Automobiles | TVS Motor Company Limited |  | 5.039200402825869 |  |  |  | 9
 |  |  | Consumer Durables | Voltas Limited |  | 3.493323106011208 |  |  |  | 16
 |  |  | Consumer Durables | Blue Star Limited |  | 1.074555036659353 |  |  |  | 29
 |  |  | Consumer Durables | Kajaria Ceramics Limited |  | 3.012939991606526 |  |  |  | 19
 |  |  | Retailing | V-Mart Retail Limited |  | 4.967954992690249 |  |  |  | 10
 |  |  | Retailing | Aditya Birla Fashion and Retail Limited |  | 3.312231805846152 |  |  |  | 18
 |  |  | IT - Software | MphasiS Limited |  | 1.079972537809179 |  |  |  | 28
 |  |  | Finance | Bajaj Finance Limited |  | -1.988602215808769 |  |  |  | 43
 |  |  | Diversified FMCG | Hindustan Unilever Limited |  | 15.275 |  |  |  | 2
 |  |  | Cement & Cement Products | JK Cement Limited |  | 11.15 |  |  |  | 4
 |  |  | Automobiles | Hero MotoCorp Limited |  | 1.145912877938893 |  |  |  | 27
 |  |  | Finance | Shriram Finance Ltd |  | 1.36902327041384 |  |  |  | 24
 |  |  | Auto Components | Endurance Technologies Limited |  | 3.489717220204533 |  |  |  | 17
 |  |  | Retailing | Avenue Supermarts Limited |  | 3.556696128005639 |  |  |  | 15
 |  |  | Banks | AU Small Finance Bank Limited |  | -0.6629793805670556 |  |  |  | 41
 |  |  | Textiles & Apparels | Page Industries Limited |  | 8.675 |  |  |  | 5
 |  |  | Realty | Oberoi Realty Limited |  | -0.9299793141996565 |  |  |  | 42
 |  |  | Realty | Anant Raj Ltd |  | 4.446244015027141 |  |  |  | 13
 |  |  | Insurance | SBI Life Insurance Company Limited |  | 13.15 |  |  |  | 3
 |  |  | Banks | RBL Bank Limited |  | -0.3672153116132548 |  |  |  | 39
 |  |  | IT - Software | Birlasoft Limited |  | 0.004160145530956264 |  |  |  | 37
 |  |  | Auto Components | Schaeffler India Limited |  | 0.05706326615196845 |  |  |  | 36
 |  |  | Commercial Services & Supplies | TeamLease Services Limited |  | -10.075 |  |  |  | 46
 |  |  | Healthcare Services | [NAME] |  | 18.725 |  |  |  | 1
 |  |  | Auto Components | [NAME] |  | 1.438701108687323 |  |  |  | 23
 |  |  | IT - Software | Wipro Limited |  | 0.4038111478417713 |  |  |  | 35
 |  |  | Consumer Durables | Whirlpool of India Limited |  | 0.7470760274176719 |  |  |  | 31
 |  |  | Finance | Mas Financial Services Limited |  | -2.09335291209755 |  |  |  | 44
 |  |  | Transport Services | InterGlobe Aviation Limited |  | 4.649999999999999 |  |  |  | 12
 |  |  | Pharmaceuticals & Biotechnology | Cipla Limited |  | 6.975 |  |  |  | 7
 |  |  | Financial Technology (Fintech) | One 97 Communications Limited |  | 5.975000000000001 |  |  |  | 8