Displaying the penultimate rightmost data in a row with sparse data

[cloudwalking]

Thank you to everyone who has helped me over the past few days, can't thank you all enough!

The other day I was kindly helped regarding a query I had in being able to find the rightmost piece of data in a sparse row with the formula:

=IF(COUNT(G2:BE2)=0,"",LOOKUP(100000000000,G2:BE2))

I am also wondering if it's possible to find the penultimate rightmost data in the row and even the one preceding that? This seems extremely complicated!

many thanks!

[cloudwalking]

Sorry for reposting this, but I am wondering if someone could help who may not have seen this?

I am desperate to calculate the penultimate rightmost data entry in a sparsley populated row. I don't even know if this can be done? Any help would be fantastic!

thanks again!

[Max, Singapore]

Here's one tinker ...
Array-enter (ie press CTRL+SHIFT+ENTER to confirm the formula) into say, A2:
=IF(COUNTA(G2:BE2)=0,"",INDEX(G2:BE2,LARGE(IF(G2:BE2<>"",COLUMN(G2:BE2)),2)-MIN(COLUMN(G2:BE2))+1))
--------------------
Yes? Wave it, hit the little star at the bottom left of my response

[cloudwalking]

Hey, It just returns #VALUE! Have I done something wrong?

[cloudwalking]

Once I worked out array-enter it worked brilliantly! Thank you so much!!! Unfortunately the rows with 1 or 0 entries return #NUM!, can this be fixed at all?

[Max, Singapore]

Just change the front error trap: =IF(COUNTA(G2:BE2)=0,"", ...
to this: =IF(COUNTA(G2:BE2)<2,"", ...
-------------
Yess? Hit the little star at the bottom left of my response

[cloudwalking]

Still returns #NUM!

[Max, Singapore]

Unable to test right now over here, but you could try ISERROR to trap all errors (can dump the COUNTA check)
Indicatively it looks like this:
=IF(ISERROR(INDEX(...)),"",INDEX(...))
where INDEX(...) is the core expression given earlier
------------------
Checks out fine?, hit it ... that little star at the bottom left of my responses

[cloudwalking]

Hey, I tried (E2):

=IF(ISERROR(INDEX(I2:FF2,1,0)),"",INDEX(I2:FF2,LARGE(IF(I2:FF2<>"",COLUMN(I2:FF2)),2)-MIN(COLUMN(I2:FF2))+1))

but still returns a #NUM! error. Thanks for all your help so far!

[Max, Singapore]

What I meant in the indicatives was to put the same Index(...) within the ISERROR, like this:
=IF(ISERROR(INDEX(I2:FF2,LARGE(IF(I2:FF2<>"",COLUMN(I2:FF2)),2)-MIN(COLUMN(I2:FF2))+1))),"",INDEX(I2:FF2,LARGE(IF(I2:FF2<>"",COLUMN(I2:FF2)),2)-MIN(COLUMN(I2:FF2))+1))

[cloudwalking]

Thats superb thank you!