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
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