Forum Discussion
Solved
Formulas and functions in EXCEL
Hi guys, I am having trouble with this formula which basically helps me arrange data in a descending order, I am creating a budget sheet, and triple checked it, but everytime it gets me this #REF! er...
If you change dot on semicolon in formula which generates the range address, it works.
First #REF! is since the reference on empty cell on top left.
Perhaps you mean semicolon instead of dot to combine ADDRESSes.