I have a very long spreadsheet that has a column with different tactics in it. I want to create a formula to look at a specfic column (column H) in the spreadsheet and tell me if the word "cloud" or "virtualization" is present anywhere in that cell. So if cloud is in h3 then put the word cloud in column i. If virtualization is anywhere in column H, then put virtualization in column i.
Is there a formula that can do both cloud and virtualization in 1 formula?
Any help would be much appreciated!
Last edited by Koda7; 01-06-2011 at 12:21 PM.
You would do best to post a sample workbook showing your Sheet Layout and perhaps Before and After examples.
It should clearly illustrate your problem and not contain any sensitive data.
Cheers
Will it be only single words in the cells?
If not:
=IF(COUNTIF(H:H,"*cloud*"),"cloud",IF(COUNTIF(H:H,"*visualization*"),"visualization",""))
If so, then remove the *'s
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Thanks NBVC, that worked like a charm!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks