Excel Filter

[Neilsen69]

Hi,

I have a list of schools in a column. I need to filter this list or column by searching for key words such as "High School" "elementary School" or "Middle school" since all the schools have different names, it would be a great help if I could sort them by these categories.

Does anyone know this formula, I believe a IF formula is needed, but I am kinda IFFY on that formula. lol

[Whizbang]

Please upload a sample workbook demonstrating your intended outcome.

[Neilsen69]

Please upload a sample workbook demonstrating your intended outcome.

Thanks for your reply, I don't know how to upload on here.

Lets say column A looks like this.

Charles T.Young Elementary
Batavia High School
Hamilton High School
Northland High School
Northeast Career Center Vocat
Starling Middle School
Franklin Alternative Middle
Rosemore Junior High School
Hamilton Middle School
Hilliard Station Sixth Grade
Finland Middle School
Eastland Career Center Vocati
Henry Karrer Middle School
Perry Middle School
Centennial High School
Educational service Center of Central Ohio
Canal Winchester Intermediate
Scioto County Vocational Scho
Piketon Junior High School
Wilson Middle School
Kyger Creek Middle School
Wellston High School
Tri-Rivers Career Center Voca

I want to separate or pull out the high schools, or elementary schools etc.

[ron2k_1]

See if the attached instructions help.

Let us know if it helps

[Neilsen69]

See if the attached instructions help.

Let us know if it helps

Yes it worked thank you very nuch