How to create a reverse sort on an Excel array

Question

I have an array of 250 elements "myArray (1 to 250)". Is there a built-in excel for mac function that can give me a reverse number list? For example if I wanted to loop through the array from the last number to the first (250 to 1), the last number could have a pointer as the 1st item processed in my loop ie. 250 is the 1st processed, 249 is the second processed, 248 is the third, etc? My goal is using a built-in function vs creating a logic loop.

In VBA for PC, For X = 250 to 1 Step -1

Ron Rosenfeld
– Ron Rosenfeld

2016-02-02 01:51:16 +00:00
Commented Feb 2, 2016 at 1:51 — Ron Rosenfeld
– Ron Rosenfeld, Commented Feb 2, 2016 at 1:51

Ron Rosenfeld · Accepted Answer · 2016-02-02 01:58:27Z

1

Is there a special requirement in VBA / MAC that precludes negative Step counters?

If not, just do something like:

For X = Ubound(myArray) to Lbound(myArray) Step -1
    Do Something
Next X

answered Feb 2, 2016 at 1:58

Ron Rosenfeld

62k7 gold badges35 silver badges71 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to create a reverse sort on an Excel array

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related