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.
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
Sure, here it is
https://docs.google.com/spreadsheets/d/13XsFmtD-HRUB61gZ3nCfZLhdDfGC9vb5/edit?usp=drive_link&ouid=107303868009248312118&rtpof=true&sd=true
- https://docs.google.com/spreadsheets/d/13XsFmtD-HRUB61gZ3nCfZLhdDfGC9vb5/edit#gid=476618940
Try this one please
