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:
. 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!
Code:
=IF(A1=C1,"Same",A1-C1)