How to create an inverted array

Hello Excel gurus, I'm back, I'm learning excel

I'm tryng to create a big formula but in he first step i'm already stuck
What I'm tryng to do is create an inverted array
you see the image and you will understand, I was lookin for a function to add just after the index to convert the array
Thank you so much

\1

If this was your data...

A2: 88
A3: 13
A4: 73
A5: 65
A6: 10

This formula segment will generate the inverted array {10;65;73;13;88}...

SUBTOTAL(9,OFFSET(A6,-(ROW(A2:A6)-ROW(A2)),0))

Here's a sample file demonstrates this.

Originally Posted by sanram

See the attachment if you are trying to achieve this.
=INDEX(A$3:A$8,COUNT(A3:A$8))

That's not what they're trying to achieve.

They want to refer to the inverted array within a larger formula.

Originally Posted by Tony Valko

Here's a sample file demonstrates this.

Yes! Yes! Yess!! Valkoooo!!!
Excellent exactlly what i needed...
Woow I understand very well your formula and now I can put it inside my big formula..

@Sanram
Thank you also for yor help
Bye



\1

You're welcome. Thanks for the feedback!