Hi can someone help me with a formula please?.....
I want to have 0,1 or 2 in column B depending on text in column A
Column A Column B
Macks 1
Macks/Baxter 2
CFL 0
CFL/Langmead 1
So if the cell doesn't contain CFL and it doesn't contain a "/" then its 1
If it doesn't contain CFL and it does contain a "/" its 2
If its CFL only its 0
it it contains CFl and it contains a "/" its 1
I have tried lots of different ways and it works almost except it wont work on either the CFL/ or the MACKS/BAXTER
this is the formula I have at the moment and have stopped at
But it returns 2 where its CFL/
Any help on this would be very appreciated as ive been spending the last hour or so trying to get his right....
Thanks
Dan
Bookmarks