Applying a rule to an entire column in Numbers '09?

Discussion in 'Mac Apps and Mac App Store' started by jent, Mar 29, 2011.

  1. jent macrumors 6502a

    jent

    Joined:
    Mar 31, 2010
    #1
    I have a Numbers spreadsheet in which I have Column A and Column C, which have thousands of rows' worth of data. Between them is Column B, which I want to have a simple formula: if the numbers in a row are the same in the Columns A and C, then write "Same" in Column B, otherwise, display the difference. The code itself is simple:
    Code:
    =IF(A1=C1,"Same",A1-C1)
    . Because I have tens of thousands of rows, it would take about thirty minutes for me to drag cell B1 all the way to the last cell in Column B, applying the formula to every cell in Column B. Is there a menu bar item or keyboard shortcut to apply a formula in a single cell to an entire column? Thanks for your help!
     
  2. jent thread starter macrumors 6502a

    jent

    Joined:
    Mar 31, 2010
    #2
    I just wanted to add, if there's no keyboard shortcut, is there some kind of script I can run or anything to achieve this?
     

Share This Page