Return the most right value in the same row

Hi, I'd like to return the value of the most right cell in the same row.

For example, the result that I want to find is column C.

Thanks a lot!

Expression

Accepted answers

@Amber0208 One way of doing this

I don't think I understood the scenario clearly.

You want values from Column C alone?

Thanks,

Krishna

Hi Krishna,

I think the example makes you confused. Actually, I have another -huge- data with date(column) and each transaction price,

looks like below:

Item 6/1 6/2 6/3 6/4 ...

A 800 - - 700

B 900 800 - -

but I would like to return the only price at the last transaction date. :

Item Last Price

A 700

B 800

However, the origin data is too big and complicated so I just find a simple example.

Thank you for your reply!

@Amber0208 One way of doing this

Thanks Binu! It works!

Most appreciated !