Formula problem

AndrewRossington

Board Regular
Joined
Oct 27, 2005
Messages
114
I have a list of over 800 schools, and I need to remove the Primary Schools from this list. I don't want to have to go through them manually!

Is there a formula I can use to check each cell for the word 'Primary' (I don't want to to see which cells ONLY have 'primary' in them, as none of them do, but to see which of the 800 cells INCLUDE the word 'primary')

I'm thinking maybe an IF formula, however I don't know how to portray "search for the word 'primary' " in the Logical Test box.

Can anyone help?
 

Some videos you may like

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

BBHRVS

Board Regular
Joined
Nov 3, 2005
Messages
94
Hello,

Why don't you use the filter functionnality ?
Just go on the title line and create a filter (menu Data/Filter/Automatic)
And then in the filter, select customized and select your condition.
Hope this helps
 

SteveO59L

Well-known Member
Joined
Apr 21, 2004
Messages
7,896
In an adjacent cell,

=IF(FIND("Primary",H7)>0,"Found","NotFound")

and copy down
 

AndrewRossington

Board Regular
Joined
Oct 27, 2005
Messages
114
Success!

Thanks chaps.

BBHRVS, your idea worked a treat.

The IF formula didn't work, I don't know why, but thanks all the same.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,069
Messages
5,570,014
Members
412,304
Latest member
citrus
Top