Creating a Top N report in an Excel Spreadsheet

  • Thread starter Thread starter Mary K. Bullock
  • Start date Start date
M

Mary K. Bullock

I have a spreadsheet in which I have inputed a series of dates from Jan 2000
through Today as my row headers and Nasdaq stock symbols as my column
headers. I would like to be able to determine the Top 5 or Top 10 days
across the entire spreadsheet. Any suggestions??? Thanks in advance.
 
Top 5 or 10 days for what though? Days per stock symbol (which I can see the
logic of), or just days across the sheet regardless (which I'm not so clear on
the logic for).

Either way you are likely going to be using Data / Filter / Autofilter, or
perhaps an INDEX/MATCH combination, or even perhaps normalising your data and
using a Pivot Table, but a bit more detail would help :-)
 
What I need to be able to do is determine which days had the top 5 or 10
producers. I thought of using a PivotTable as well as the Autofilter, but I
think the biggest problem I am having is that my date rows actually need to
be columns and my stock columns actually need to be the rows that way I
could very easily determine the Top 5 or 10 using the Autofilter. So,
actually I guess my question should be...Is there a way to shift my row
headers to be column headers and my column headers to be my row headers????
 
Back
Top