Dear all,
I have been stumped at the first stage of doing a nest if countif formula.
My problem is I need to isolate one particular group of text from other this is the if formula
I have a list like below
aeb123
kg234
qe965
aeb250
qe1001
etc
I want to isolate the aeb only but as each has a unique number after it I thought I would try "aeb*"=if(a1:a2000="aeb*" hoping it would ignore the number but it does not and return a 0 result.
This works fine in the countif section
Until I get past this bit I can continue.
Any help much appreciated
I have been stumped at the first stage of doing a nest if countif formula.
My problem is I need to isolate one particular group of text from other this is the if formula
I have a list like below
aeb123
kg234
qe965
aeb250
qe1001
etc
I want to isolate the aeb only but as each has a unique number after it I thought I would try "aeb*"=if(a1:a2000="aeb*" hoping it would ignore the number but it does not and return a 0 result.
This works fine in the countif section
Until I get past this bit I can continue.
Any help much appreciated