Ask Experts Questions for FREE Help !
Ask
    allison79's Avatar
    allison79 Posts: 7, Reputation: 1
    New Member
    		  
    #1

    Apr 26, 2007, 11:37 PM
    modulus by column
    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.
    Capuchin's Avatar
    Capuchin Posts: 5,255, Reputation: 656
    Uber Member
    		  
    #2

    Apr 26, 2007, 11:40 PM
    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?
    allison79's Avatar
    allison79 Posts: 7, Reputation: 1
    New Member
    		  
    #3

    Apr 27, 2007, 12:35 AM
    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...
    Capuchin's Avatar
    Capuchin Posts: 5,255, Reputation: 656
    Uber Member
    		  
    #4

    Apr 27, 2007, 12:38 AM
    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.
    allison79's Avatar
    allison79 Posts: 7, Reputation: 1
    New Member
    		  
    #5

    Apr 27, 2007, 01:14 AM
    You are a genius, thank you!
    Capuchin's Avatar
    Capuchin Posts: 5,255, Reputation: 656
    Uber Member
    		  
    #6

    Apr 27, 2007, 01:17 AM
    I aim to please ;)
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

What is a water column [ 10 Answers ]

My question is actually two questions in one. I believe that in my studies in school I learned that a water column is a stand of water in a pipe to a certain height. If the pipe ended at the bottom of a tank then the water column would extend up through the water in the tank to the water level but...

4 Column Accounts [ 3 Answers ]

Ok here is the information I have and what I have done with it thus far, I guess I am not sure exactly what it is asking of me? Account # Account Title Debit Credit 11 Cash... $ 4,900 12 Accounts Receivable... 15,310...

How to find unique values in an entire column [ 10 Answers ]

hi all please tell me how can I findout the unique values in an entire coloumn. for example I have 3 coloumn in an sheet. Name Prod. Value a 24 100 b 26 240 a 33 120 a 21 200

Error Message - Column Not Allowed Here [ 3 Answers ]

I tried to create a table and got the following message: COLUMN NOT ALLOWED HERE. What is the solution for this? Regards MATHEW

View more questions Search