SOLVED

Formulas and functions in EXCEL

Copper Contributor

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.

 

ReneCeballos_MD_1-1701207142601.png

 

 

 

 

10 Replies

@ReneCeballos_MD 

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?

@ReneCeballos_MD 

Perhaps you mean semicolon instead of dot to combine ADDRESSes.

@ReneCeballos_MD 

Link doesn't work for me

image.png

@ReneCeballos_MD 

Still a problem: "The organization that owns this item doesn't allow you to access it"

best response confirmed by ReneCeballos_MD (Copper Contributor)
Solution

@ReneCeballos_MD 

If you change dot on semicolon in formula which generates the range address, it works.

image.png

First #REF! is since the reference on empty cell on top left.

 

Thanks a lot!

@ReneCeballos_MD , you are welcome

1 best response

Accepted Solutions
best response confirmed by ReneCeballos_MD (Copper Contributor)
Solution

@ReneCeballos_MD 

If you change dot on semicolon in formula which generates the range address, it works.

image.png

First #REF! is since the reference on empty cell on top left.

 

View solution in original post