Get rightmost non date value in a row

[SingularitysPoint]

We have numerous sheets of thickness readings. They take the form of something similar to:

ITEM	POS	BASE THK	BASE DATE	THICKNESS	DATE	THICKNESS	DATE	THICKNESS	DATE
001	A	5.1	11/06/15	4.9	13/06/23	536	25/09/19	5.1	11/06/15
002	B	7.6	25/09/19	8.25	13/06/23	7.6	25/09/19	N	11/06/15
003	C	5.2	11/06/15	5.1	13/06/23	5.3	25/09/19	5.2	11/06/15

The number of columns after the Item and Position can vary, depending on how many readings we have but, if there isn't a reading one year, the survey date is still entered and an 'N' (for No Reading) is entered.

What I need to get (in the BASETHK and BASEDATE cells) is the rightmost thickness reading for one, and the respective date for the other. The colouring above is purely to show where the results in the BASE columns are coming from.

Is this possible? I've Google lots, and tried LOOKUP, INDEX/MATCH and so on, but without real success.

 

[SingularitysPoint]

For future reference.

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Get rightmost non-date or text value in a row [SOLVED]
There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

Thanks Fluff. I didn't realise and needed an answer as soon as possible to prevent my team spending hours on something they didn't need to. I apologise.

 

[Peter_SSs]

... to prevent my team spending hours on something they didn't need to.

Yet that meant our (unpaid) team spent hours on something we did not need to, given the problem was solved on the other forum some 2 hours before my posts 6 & 7 here.

 

[SingularitysPoint]

Yet that meant our (unpaid) team spent hours on something we did not need to, given the problem was solved on the other forum some 2 hours before my posts 6 & 7 here.

I apologise. I really didn't mean for that to happen and am extremeley grateful for all help given.

 

[Peter_SSs]

Apology accepted. Just remember to provide any cross-post links on both/all forums in the future.
It is also worth considering whether posting on multiple forums actually makes things faster. There are numerous helpers in all forums that will just pass over your thread if it is cross-posted because they do not want to bother trying to monitor multiple forums to see if an answer &/or additional information has been provided elsewhere. So you may have two forums in play, but less potential helpers in each one.

 

[SingularitysPoint]

Apology accepted. Just remember to provide any cross-post links on both/all forums in the future.
It is also worth considering whether posting on multiple forums actually makes things faster. There are numerous helpers in all forums that will just pass over your thread if it is cross-posted because they do not want to bother trying to monitor multiple forums to see if an answer &/or additional information has been provided elsewhere. So you may have two forums in play, but less potential helpers in each one.

I do see your point, and thanks again for your help.

 

[Peter_SSs]

Cheers.