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 29, 2023

HansVogelaar 

Sure, here it is

 

https://docs.google.com/spreadsheets/d/13XsFmtD-HRUB61gZ3nCfZLhdDfGC9vb5/edit?usp=drive_link&ouid=107303868009248312118&rtpof=true&sd=true

  • ReneCeballos_MD's avatar
    ReneCeballos_MD
    Copper Contributor
    Nov 29, 2023
    https://docs.google.com/spreadsheets/d/13XsFmtD-HRUB61gZ3nCfZLhdDfGC9vb5/edit#gid=476618940

    Try this one please
    • HansVogelaar's avatar
      HansVogelaar
      MVP
      Nov 29, 2023

      ReneCeballos_MD 

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

      • 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

Resources