| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Creating a Rankings Table
My data comes in like so:
Symbol Firm Volume QQQQ BOX549 97,349 QQQQ BOX912 95,172 QQQQ BOX919 90,111 QQQQ BOX980 71,068 QQQQ BOX910 37,991 QQQQ BOX642 30,145 QQQQ BOX913 11,514 AAPL BOX910 39,285 AAPL BOX919 34,443 AAPL BOX980 26,750 AAPL BOX549 26,493 AAPL BOX642 24,276 I am trying to create this table of rankings (for example): BOX549 BOX912 BOX919 QQQQ 1 2 3 AAPL 3 2 I s there a way to pull this off ? Thank you in advance. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| updating pivot table to include additional rows | Excel Discussion (Misc queries) | |||
| Change Data In Pivot Table | New Users to Excel | |||
| Creating a Pivot Table | Charts and Charting in Excel | |||
| Creating a cell so data goes into a table | Excel Discussion (Misc queries) | |||
| Pivot Tables, Help? | Excel Discussion (Misc queries) | |||
Linear Mode
