Find data in 1 column before last column

[KIM Chanthan]

Hi,

Do you have any best way to get the data in 1 column before last column?
Please view attached file for more detail.

Thanks for your kind support.
Chanthan

 

[NARAYANK991]

Hi ,

Try this in C3 , and copy it down :

=INDEX(3:3, MATCH(99999,$2:$2) - 1)

Narayan

 

[KIM Chanthan]

It works perfectly. Thanks alot