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?
 

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 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,899
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.
 

Forum statistics

Threads
1,172,104
Messages
5,879,150
Members
433,400
Latest member
Gmoney69

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top