Quote:
Originally Posted by fotze
Are the numbers always 7 digits long? Is it always number,letter,number,number,number,number,letter,n umber?
If so its easy.
=IF((RIGHT(LEFT(A8,2),1)&RIGHT(A8,1))="bb","YAY"," BOO")
where A8 is the cell with the acct number.
|
yes they are always 7 long you had it but added an extra number
number,letter,number,number,number,number,letter
First letter is always B and I need to search for the second letter that is also a B
All account numbers are in cells a1 to a1796