I have a column of numbers for example from A1 to A250 etc and I wish to mark somehow when the number is divisible by 15 exactly
so you could say I want to sort & mark the numbers divisible by 15 only
ie ColA1/15 to ColA14/15 the answer would be NIL as there's a remainder so no mark
ColA15 /15 =1 ( that would mean marking the cell somehow( or another cell , the simplest way)
Col16/15 to Col29/15 answer is nil again ( no mark, not divisible by 15 equally)
Col30 /15 =2 -- again a mark made
etc
MOD15 would divide the cells ok, but how to mark the cells divisible by 15?
I'd appreciate any help or advice here
thanks
Keith
so you could say I want to sort & mark the numbers divisible by 15 only
ie ColA1/15 to ColA14/15 the answer would be NIL as there's a remainder so no mark
ColA15 /15 =1 ( that would mean marking the cell somehow( or another cell , the simplest way)
Col16/15 to Col29/15 answer is nil again ( no mark, not divisible by 15 equally)
Col30 /15 =2 -- again a mark made
etc
MOD15 would divide the cells ok, but how to mark the cells divisible by 15?
I'd appreciate any help or advice here
thanks
Keith