Forum Discussion
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! error.
=IF(is_cat, RANK(comb_rank, INDIRECT(comb_rank_range), 1), "")
The blue arrow is where the error displays, which has the red arrow formula as precedent.
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.
10 Replies
Perhaps you mean semicolon instead of dot to combine ADDRESSes.
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
