Return the last (furthest Right) entry in a row

[citadel-maritime]

Good day All,

Once again stuck. Is there a formula that will return the furthest right/last entry in a row into a cell

EG

In Cell B1 i would like it to show the furthest right/last entry in row A.

Thanks as always.

Claire.

[bebo021999]

What kind of entries are they? text or value (ascending or not?)?

[citadel-maritime]

It is both numeric and Text, not in any ascending order.

What I ended up using was =LOOKUP(2,1/(44:44<>""),44:44) for row 44, but now i need one that will find the second to last entry in a row? But I'm not sure how to do it, or convert the current formula?

Any help would be greatly appreciated.

[oeldere]

See here for a simular threat.

http://www.excelforum.com/excel-form...ml#post4104450