Return the most right value in the same row

[Amber0208]

 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! 

[KrishnaChithrathil]

@Amber0208 

I don't think I understood the scenario clearly.

You want values from Column C alone?

Thanks,

Krishna

[Amber0208]

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!

[binuacs · Accepted solution]

@Amber0208 One way of doing this

[Amber0208]

  Thanks Binu! It works! :) 

Most appreciated !