Hi All, I have search various ways, but could not find an answer to this question. Any ideas would be great!
I have a list of unlimited possibilities and need to identify where a specific string is in a column. Okay here we go....
I believe I need to be able to do some sort of IF statement that will give me a 1 if the 1 is exactly where I need it with the exact number of characters behind it.
I tried version of the following, =COUNTIF(A8,"1????"), =IF($A8<>"100??","1","")
So in the attachment, for column B, if 1 has four characters after it, give me a 1. In column D, if 1 has two characters after it, give me a 1, in column E, if a 1 has no characters behind it, give me a 1. I have tried COUNTIFs and IFs to no avail. Please help.
Thank you,
TerryLynn