Get rightmost non-date or text value in a row

Welcome to the forum.

The issue is that dates are just numbers, so will any of the other numbers be equal to or higher than the minumum serial number date in your dataset?

There are instructions at the top of the page explaining how to attach your sample workbook (yellow banner: HOW TO ATTACH YOUR SAMPLE WORKBOOK). Screenshots are of little practical use as we cannot manipulate them.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.

Thanks - and good (not everybody realiese this). I'll wait for the workbook, but column headers will probably come into play.

Maybe this:

=LOOKUP(2,1/($E$1:$J$1="THICKNESS"),E2:J2)

and this:

=LOOKUP(2,1/($E$1:$J$1="THICKNESS"),F2:K2)

Thank you for your help. Unfortunately, that's only showing the rightmost results for each.

If you want to exclude not numberic thickness, for example thickness = N,

Please try in C2 and copy down:

Formula:

=XLOOKUP(1,(E$1:J$1="THICKNESS")*(ISNUMBER(E2:J2)),E2:J2,"",0,-1)

and try in D2 and copy down:

Formula:

=XLOOKUP(1,(F$1:J$1="DATE")*(ISNUMBER(E2:I2)),F2:J2,"",0,-1)

Brilliant. That works perfectly. Thank you.

Glad to have helped.

If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED.

Also, if you have not already done so, you may not be aware that you can thank anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.

Glad to have helped .

You've saved SO much work. It's appreciated.

Thanks for your feedback.

Please considder adding reputation to any helpers you think they deserve.
In that case please click * Add Reputationleft below their answers.

Administrative Note:

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not told us about this. You are required to do so.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important: https://excelguru.ca/a-message-to-forum-cross-posters/

(Note: this requirement is not optional. As you are new here, I shall do it for you this time: https://www.mrexcel.com/board/thread...a-row.1239227/)

My apologies. I'll ensure this is done in future. The help given was immensely helpful in tight time constraints.