Perfect, yup the second one works perfectly with the IF statement. Thank you for helping me!
One last question for you... is there an easy way to copy this down my 60000 rows? if I just do the simple fill down or highlight and drag down it changes the k1, k31 to k2, k32 etc but i need the...