#VALUE! error generated on Index : Index

[mookyon]

Dear All,

I am using Excel 365 and encountered a #VALUE! error in this (solely constants, no auxiliary variables) code segment:

=LET(_vec_,{10;4;78;19;5;15},
_rows_,ROWS(_vec_),
_min_,MIN(_vec_),
_pos_,XMATCH(_min_,_vec_),
_original_,MAX(INDEX(_vec_,_pos_):INDEX(_vec_,_rows_)),
_alternative_,MAX(INDEX(_vec_,SEQUENCE(_rows_-_pos_+1,1,_pos_,1))),
_original_
)

An alternative solution is also presented (just replace _original_ at the end of the LET function to _alternarive_). I prefer to use _original_ but it failed to perform.
Can someone decipher the root of this error.

-1000 THX

 

[Fluff]

You get the error because you are feeding the INDEX function an array & not a range & so cannot use Index():Index().
Another option is to use

MAX(DROP(_vec_,_pos_))

 

[mookyon]

Sure. Thank you very much for the DROP idea.

 

[Fluff]

You're welcome & thanks for the feedback.