organizing data

Miss_Excel_Novice

New Member
Joined
Sep 29, 2006
Messages
6
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!
 

Some videos you may like

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).

jfuredy

Board Regular
Joined
Mar 11, 2003
Messages
72
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
 

Watch MrExcel Video

Forum statistics

Threads
1,114,051
Messages
5,545,726
Members
410,702
Latest member
clizama18
Top