How can I get "Calculated Columns" to work in excel?
- by Shawn Persels
Using Excel 2010, I want a single formula to apply to all cells in a column.
I see documentation for a feature called "Calculated Columns". That is exactly what I want, but when I follow the instructions I only end up creating a formulate in a single cell - not the whole column.
I don't want to use "Fill" or "Copy" because the number or rows in the sheet changes periodically and maintaining the formulas would be very tedious.