Forum Discussion

ReneCeballos_MD's avatar
ReneCeballos_MD
Copper Contributor
Nov 28, 2023
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...
Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    Nov 30, 2023

    ReneCeballos_MD 

    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.

     

ReneCeballos_MD's avatar
ReneCeballos_MD
Copper Contributor
Nov 30, 2023
https://docs.google.com/spreadsheets/d/1q5veDuXxOYUwDibcGEfemUCLTuem4Hj5/edit?usp=sharing&ouid=112318008839579001591&rtpof=true&sd=true

Here it is. Sorry for the inconvenience
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Nov 30, 2023

ReneCeballos_MD 

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.

 

Resources