Sorry for delayed reply. Thank you very much Mynda for all your time & help in the matter. This should help. Once again, truly appreciate w...
Hi Mynda, Sorry I couldn't recognize that didn't got uploaded properly; but now attached. Arun
Hi Mike, MCD resulting as 0.62073 due to Dividend transaction. Arun
Hi Mike, I noticed that your Lot #1 2020-04-16 Buy 32x AMZN is showing as Interest in Col C ( Action) and not Buy. Arun
Hi Mynda, Hope you had a great weekend. I fixed the data now, please help to calculate now col J K L for table ACB so it gives results as per ta...
Hi Mynda, Thanks for your quick response always. Sorry for delayed reply. Yes your SUMIFS did the job to Balance Qty but didn't gave desired ...
Hi Mynda, First of all I appreciate your time and efforts for quick reply & simplified formula re IFERROR. Yes I accept times are not in ac...