Hi

You should always show your expected result as it will allow us to understand your needs better.

See if this is what you actually wanted.

Sunny

Thank you so much, Sunny,

The rate 2 column is exactly what I want.

I have a little issue now. When I try to apply that to my current workbook, I have a following message.

Please let me know what did I do incorrectly.

Regards,

Aye

Can you post the data file for me to take a look?

It is difficult to tell from your screenshot.

It could be your data, header name etc.

Hi Sunny,

It is in fact header name.

Thank you so much.

Regards,

Aye

Hi Aye Mu

Thanks for your feedback.

Happy to know it is working.

Cheers

Sunny

Hi Sunny,

I cant thank enough for all My online training hub team's prompt responses.

I will definitely have to be life long member of this forum.

Regards,

Aye