Consider a single row and ten columns.

Some or all or none of the cells in the row will have non-numerical data.

Can anyone provide a formula that will display the next-to-last, non-blank,
rightmost value in the row?

From the sample data below, the result would be "Dog"
Column A - Mom
Column B - Dad
Column C - (blank)
Column D - Sis
Column E -(blank)
Column F - Bro
Column G - Dog
Column H - (blank)
Column I - (blank)
Column J - Cat
Column K - (FORMULA WHICH PROVIDES THE ANSWER)

Thank you for your consideration and support.