help with forumla please...

  • Thread starter Thread starter mintyman
  • Start date Start date
M

mintyman

Hi,

I have 2 columns in a worksheet. Column 1 has a list of company names.
Column 2 is currently blank.

I need to place a "13" in column 2 wherever the company name in column
1 contains the text "university" or "college". Otherwise, a "14" should
be entered.

I can get this to work if I use:

=IF (A16 = "Sheffield University", 13, 14)

but this only works for the exact string. Can anyone show me how to do
this where a field CONTAINS a specified word instead of an exact
string?
 
One way

=IF(OR(ISNUMBER(SEARCH("university",A16)),ISNUMBER(SEARCH("college",A16))),1
3,14)
 
Hi

Use Data/Filter/Autofilter and set column 1 to custom to either contain
"university" or "college". Once it is filtered you can input your 13. Filter
the opposite and fill in your 14.

Andy
 
Back
Top