Excel Help

[JohnnyM]

I have a big sheet with 50+ columns of info.

Let's say column "B" is "Name" and column "F" is "State"

Is there a way, on another sheet, I can make it list all the Names for people from a certain State?

I think the answer is going to use VLOOKUP, but the only way I know how to make that work is if you're matching something from the first column, and then that column has to be sorted.

Anyone?

Example:
-----------------------------------------------
------ A ------ B ------- C ------- D -------E
1 ----ID ------Name--DOB----State---City
2 ----1 -----Billy -----6/1/05 ---CA ----Encino
3 ----2 -----Frank --1/1/83 ----TX ----Austin
4 ----3 -----Dilbert---7/4/76 ---CA ---San Diego

Then on another sheet I want it to be able to list all the Names of people from CA

 

[BrûléeOrange]

I'm a novice, but have you tried using "pivot tables"?

 

[JohnnyM]

I dont know what pivot tables are to be honest.

I have found out my answer. Its a combination of INDEX, SMALL, IF, and ROW.

 

[EuroHorn]

You should try Microsoft Access. It is pretty easy to learn and you can do much more database stuff than Excel.

 

[JohnnyM]

well i only use this monster spreadsheet once per year (for my masters pool) and thus i dont have any desire to move all these formulas over to access.

 

[AstroVol]

(From the top menu)

Data - Filter - AutoFilter

Click on the tab next to "state" and then click on "CA" from the pulldown menu, for example.