Forum

This function is for the security that pays interest rate on maturity date. Hence all the cash flow is fixed that is principal we pay and return we re...

Thank you so much Anders and thanks for the formula in column AY too. It works well. I will definitely look forward to learn Power Query in the future...

There are two tables viz JAN and CASH01. Each have their second column as 'DATE'. The dates in both column can be same if I execute trades in both the...

I have attached the file. I have tried with some formula but it doesn't work in older versions of Excel because of two different columns. Can you plea...