Automatically create top ten lists

**grey_fox33** · 08-17-2011, 12:05 AM

Say that I have a large set of data on one sheet that contains
column 1 = names of students
column 2 = the school that they attended
column 3 = their GPA

The data is unsorted.

On another sheet I want to have various top ten lists, for example the first top ten could be top ten GPA overall sorted from highest to lowest. The second list below that would be top ten GPA for a particular school sorted from highest to lowest. Then there is another list, the bottom 10 GPA.

I want to have it so if the data in the other sheet is changed the lists in the other page all update automatically. What do you suggest I use to accomplish something like this?

**JBeaucaire** · 08-17-2011, 12:30 AM

I would have a series of columns off to the right of the data that "ranks" each row of information based on the current data in those first few columns. Each rank formula would be for a different function.

If you design this workbook, put 50-100 sample rows of data in it, then add a second sheet showing the TOP 10 lists as you want to see them, I can show you how to add the rank columns on the data sheet and add formulas to your Top Ten sheet.

So, do your layout, manually mockup sample data and sample results, be thorough, then we'll take it from there together.

Click GO ADVANCED and use the paperclip icon to post up a copy of your workbook.

Automatically create top ten lists

LinkBack

Thread Tools

Rate This Thread

Display

Automatically create top ten lists

Re: Automatically create top ten lists

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions