Hi all,
I have a spreadsheet that I want to use to break down chat in our chat rooms.
In column A I have the chat, one sentence per row.
Over the next few columns I have used a formula I have found online to search the sentence for set key words like GL & Good Luck then to put a 1 in the cell to the right of the sentence.
=IF(ISERROR(SEARCH("*gl*",A6,1)),IF(ISERROR(SEARCH("*good luck*",A6,1)),"","1 "), "1")
This is working fine, its getting hits off as required. However I have 2 issues:
1) When I use the =SUM command to add the column up all I get is 0. There are eleven 1's in my current example but it still totals 0.
2) How can I change the above formula to state that, If you find these key words put a 0 in the column otherwise put a 1 in it?
I hope someone can help?
I have a spreadsheet that I want to use to break down chat in our chat rooms.
In column A I have the chat, one sentence per row.
Over the next few columns I have used a formula I have found online to search the sentence for set key words like GL & Good Luck then to put a 1 in the cell to the right of the sentence.
=IF(ISERROR(SEARCH("*gl*",A6,1)),IF(ISERROR(SEARCH("*good luck*",A6,1)),"","1 "), "1")
This is working fine, its getting hits off as required. However I have 2 issues:
1) When I use the =SUM command to add the column up all I get is 0. There are eleven 1's in my current example but it still totals 0.
2) How can I change the above formula to state that, If you find these key words put a 0 in the column otherwise put a 1 in it?
I hope someone can help?