I have a messy sheet calculation that needs tidying
Basically I am identifying RACE TYPE , so as an example , say I was looking for Claiming, then I would use in cell R8
- Code: Select all
=IF(FINDB("Claim",A8,1),1,0)
Which is fine when A8 contains "Claim" within the race title - but when it doesn't - i get #VALUE!
to get away from the mess , the next column , cell S8 has
- Code: Select all
=IF(ISERROR(R8),0,R8)
Since i plan on changing this to vba shortly - could anyone give me a pointer as to how this would be done in vba ?
cheers