Offset Match Formula

[Pibsandsquibs]

Hello

I have formula that reads a number of dates entered left to right in a particular row and returns the current arrival date in the column the formula is in. Below is the formula I use. Is there a way to switch that to read the information from right to left? So in my example the I would be entering the oldest information (which is under 22/07) to the right and the the newest information (which is under 26/07) to the left.

=OFFSET(K51,0,MATCH(MAX(K51:CO51)+1,K51:CO51,1)-1)

Current example is for row 51 and the info is below. The date returned is 30/08/24.

 

[arthurbr]

Most of what you explain is not visible. One way is =INDEX(target_row_range,MATCH(MAX(source_row_range),source_row_range,0)) if both rows begin in the same column, which cannot be deduced from your very short example/explanation

 

[Peter_SSs]

For the original problem, instead of using the volatile function OFFSET, would this non-volatile formula do the same job?

=LOOKUP(9^9,K51:CO51)

Perhaps this for the new question?

=INDEX(FILTER(K51:CO51,K51:CO51<>"",""),1)