Searching for products and categorizing.
 

I've got a tricky one, well for me anyway.

I need to classify a list of products into Hardware and Software. The
trouble is the items can be called Licensed Software, Security Software,
renewal Software, etc... Want I want to be able to do is do an IF formula
that categorizes a cell as Software if the phrase containes Software in it,
does that make sense?

Hardware I'm not to bothered with as if it doesent classify as Software then
it has to be Hardware (as all the software products state so somewhere in the
product name)

Apologies if this is a bit confusing.

Thanks

Searching for products and categorizing.
 

Try the below
=IF(A1="","",IF(ISNUMBER(SEARCH("software",A1)),"S oftware","Hardware"))

If this post helps click Yes
---------------
Jacob Skaria


"Nicholas1" wrote:

I've got a tricky one, well for me anyway.

I need to classify a list of products into Hardware and Software. The
trouble is the items can be called Licensed Software, Security Software,
renewal Software, etc... Want I want to be able to do is do an IF formula
that categorizes a cell as Software if the phrase containes Software in it,
does that make sense?

Hardware I'm not to bothered with as if it doesent classify as Software then
it has to be Hardware (as all the software products state so somewhere in the
product name)

Apologies if this is a bit confusing.

Thanks

Searching for products and categorizing.
 

Try this in B2, assuming your data starts in A2:

=IF(ISNUMBER(SEARCH("software",A2)),"Software","Ha rdware")

Copy down as required.

Hope this helps.

Pete

On Oct 28, 3:54*pm, Nicholas1
wrote:
I've got a tricky one, well for me anyway.

I need to classify a list of products into Hardware and Software. The
trouble is the items can be called Licensed Software, Security Software,
renewal Software, etc... Want I want to be able to do is do an IF formula
that categorizes a cell as Software if the phrase containes Software in it,
does that make sense?

Hardware I'm not to bothered with as if it doesent classify as Software then
it has to be Hardware (as all the software products state so somewhere in the
product name)

Apologies if this is a bit confusing.

Thanks