Forum Discussion

RaphaelBM's avatar
RaphaelBM
Copper Contributor
Apr 11, 2023
Solved

Cannot use Named Range in SORT Constant

Hi, This is about the SORT CONSTANT used in the [sort_index] in the Excel SORT function. Background: I have calculated the [sort_index] as a Named Range (1 cell big) in another sheet. Problem: Wh...
Formulas and Functions
  • RaphaelBM's avatar
    RaphaelBM
    Apr 12, 2023

    Patrick2788 Thanks again.

    Jos Woolley hinted that I need to specify an array and not text that merely looks like an array with curly brackets. I went ahead and created array containing those numbers and IT WORKS!

     

    Conclusion: You CAN use a named range in the sort constant - but the range must be an Array.

     

    The pic below shows my success getting this working OK. Thanks for the swift attention. 

    Problem solved. Raphael

     

    SORT constant using a Named Range

Patrick2788's avatar
Patrick2788
Silver Contributor
Apr 11, 2023
The workaround is to store the array constant directly in the named item.
RaphaelBM's avatar
RaphaelBM
Copper Contributor
Apr 12, 2023

Patrick2788 Thanks again.

Jos Woolley hinted that I need to specify an array and not text that merely looks like an array with curly brackets. I went ahead and created array containing those numbers and IT WORKS!

 

Conclusion: You CAN use a named range in the sort constant - but the range must be an Array.

 

The pic below shows my success getting this working OK. Thanks for the swift attention. 

Problem solved. Raphael

 

SORT constant using a Named Range

Resources