happy 1001
asked on
Excel - Score or Rank
Hi Experts
I have a data set which has got Two Columns, named - Product and Value % Change, respectively.
I am looking for some DIFFERENT METHODS which could be used for Ranking this data from 1 to 100, in such a manner that the Highest Positive Value gets the Highest Score i.e. 100 and the Lowest Value " it would be negative value in this data set" should get the Lowest Score of 0.
Can you please provide me some ideas in this regards. What could be various methods that could be used for such ranking purpose.
Any ideas are most welcome. If you could provide any links where such methods are described, then that would be a great help too.
I am using the following software versions -
Microsoft SQL Server Management Studio version- 12.0.2000.8,
Microsoft Office 2016 x64
and Windows 7 x64
I have attached the Excel File having the data.
Excel---Rank-or-Score.xlsx
Thanks
I have a data set which has got Two Columns, named - Product and Value % Change, respectively.
I am looking for some DIFFERENT METHODS which could be used for Ranking this data from 1 to 100, in such a manner that the Highest Positive Value gets the Highest Score i.e. 100 and the Lowest Value " it would be negative value in this data set" should get the Lowest Score of 0.
Can you please provide me some ideas in this regards. What could be various methods that could be used for such ranking purpose.
Any ideas are most welcome. If you could provide any links where such methods are described, then that would be a great help too.
I am using the following software versions -
Microsoft SQL Server Management Studio version- 12.0.2000.8,
Microsoft Office 2016 x64
and Windows 7 x64
I have attached the Excel File having the data.
Excel---Rank-or-Score.xlsx
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
@ Paul Maxwell, thanks a lot for making me aware of the options that are present in SQL Server. Highly Appreciated.
Although I am a bit confused, regarding the tool that I should use, Excel or SQL Server for this work ! Because the raw data is available within excel, and if I want to make use of SQL Server for ranking, then I will first have to find out some easy method to move this data from excel to sql server, without too much manual effort. And I am not yet able to figure out an easy way to move such data from many different excel files to sql server.
Thank you so much for the help provided.