Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
select Year,Month,exchangeRate from table.xls
where year=max(year) and month=max(Month)
Hi,
Thanks for the advice.
However it does not work.