Forum Discussion
Solved
Formulas and Functions
Hello, I was hoping someone could help me. I am having trouble attempting to create a formula in my excel spreadsheet. I would like all the cells in one column to automatically calculate ...
I pasted your example into a worksheet, then added formulas based on the one in my previous reply.
Sheet 1 is your example, Sheet2 has the formulas. The results appear to be the same.
A minor difference of function but the main difference is that I avoid scalar fill-down formulas when an array formula would do the same job!