organizing data

[Miss_Excel_Novice]

I want to see what are the 10 largest colleges in each of 20 cities and what the tuition is for each.

I have 4 columns of data, one with a list of all the colleges in the US, the next with the city the college is in, the next with the number of students, and the next with the cost of tuition.

I have no idea how to organize the data to give me just what I need. Please help!!

Many Thanks!

 

[jfuredy]

First, make sure you have column headers for your data columns. Start out by selecting your entire data area and then click on Data, Sort... and sort the data by tuition, either high to low or low to high depending on how you want it. Then (with the data still selected) click on Data, Filter, AutoFilter. This creates dropdown menus at the top of each column. Then you can select each city one at a time, and if necessary, select Top 10 in the college column. You just need to do this for each city.

Let me know if that works for you,
Joe

 

[Miss_Excel_Novice]

Thanks! Took a while, but it got the job done