Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How Do I Combine Rankings for Multiple Categories?
I am doing some screening and analysis on a stock database and I want to rank
each company according to certain criteria. There are approximately 5,000 companies in the database. So for example, suppose I rank the companies first by their respective Return on Equity. Let's say in that ranking Microsoft is number 50 of 5,000. Next I would rank the companies by sales growth. Let's say in that ranking Microsoft is 175 of 5,000. What formula, commands or spreadsheet design would I use to have Excel match all of the companies in the database with their respective scores and add the two rankings together? For example, to find Microsoft in the two lists and add the two rankings together for a total score of 225? Thanks in advance for your help. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How Do I Combine Rankings for Multiple Categories?
I would use two named ranges and the formula VLOOKUP.
For example, if the list for Return on Equity" is on range named "Return", and the sales growth in a range named "Growth", if you have "Microsoft" (or the code that you use for Microsoft on the database) on cell A1 the formula can be: =VLOOKUP(A1,Returns,2,FALSE)+VLOOKUP(A1,Growth,2,F ALSE) Hope this helps, Miguel. "Howard" wrote: I am doing some screening and analysis on a stock database and I want to rank each company according to certain criteria. There are approximately 5,000 companies in the database. So for example, suppose I rank the companies first by their respective Return on Equity. Let's say in that ranking Microsoft is number 50 of 5,000. Next I would rank the companies by sales growth. Let's say in that ranking Microsoft is 175 of 5,000. What formula, commands or spreadsheet design would I use to have Excel match all of the companies in the database with their respective scores and add the two rankings together? For example, to find Microsoft in the two lists and add the two rankings together for a total score of 225? Thanks in advance for your help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Switching Subcategories into Categories and Vice Versa | Excel Worksheet Functions | |||
How to combine text from multiple cells? | Excel Worksheet Functions | |||
Multiple charts in ChartSpace; problems with double Categories | Charts and Charting in Excel | |||
Multiple charts in ChartSpace; problems with double Categories | Charts and Charting in Excel | |||
Multiple charts in ChartSpace; problems with double Categories | Charts and Charting in Excel |