hi. I am trying to apply the modulus function to an entire column of data. I am obviously doing something wrong though, as I wind up getting the modulus value for the first cell in the column only. How can I apply the modulus function to an entire column of data? Thanks.

Well, you need to create a formula for the first cell, then drag it down the column?

Do you have $s in the formula by accident?

hi, thanks for the reply. No I don't have $s in my formula, I was doing it like this for example: =mod(A1:A186,2000). I have no clue...

You're doing the mod for the whole column in one cell? This isn't how you need to do it.

in B1 you need =mod(A1,2000)
then in B2 you need =mod(A2, 2000)

you can carry this all the way down by selecting your first number, clicking and holding the little square in the bottom right, and draggin all the way down to B186.

This should give you what I think you are looking to do.

You are a genius, thank you!

I aim to please ;)