Hi, can anyone help me on this matter?
I need to find the first and second largest sum shareholdings (%) for each company. Then, this first and second largest sum shareholdings (%) should gives the type, i.e. the classification of the shareholdings accordingly. I have attached a sample of spreadsheet with some companies. I have more than 7000 data over a 1000 companies. I'm not sure how can I do this. Please help. Thanking you in advance!!
Regards,
Mable
Bookmarks