For functions that you don't understand, I recommend that you use Excel's
help facility. It will explain, usually give examples, & often also
cross-refer to related functions.
--
David Biddulph

"twty" wrote in message
...
Thank you all for your help. I dont really understand the MOD() formula
but
all of your suggestions worked, with array and without array.