Always show the latest Rate

[tan_chungkam]

Hi all,

I have a excel table as below:

Table

I would like to do in scripting level to always show it's latest exchange rate.

Please find below as my expected outcome:

Expected Outcome

[Channa]

select Year,Month,exchangeRate from table.xls

where year=max(year) and month=max(Month)

[tan_chungkam]

Hi,

Thanks for the advice.

However it does not work.