Excel index/match/sumproduct formula help
what is the formula to populate the yellow cells?
It wasn't clear whether there should be any linkage between the values in E2 and I2 on your screenshot.
To keep things simple, I wrote formulas in the attached workbook that identify unique Buy and Sell transactions, and list them as found. You can sort by ticker if you want to try matching them up. Matching them up with formulas will harder.
StockTradeMatching.xlsx
To keep things simple, I wrote formulas in the attached workbook that identify unique Buy and Sell transactions, and list them as found. You can sort by ticker if you want to try matching them up. Matching them up with formulas will harder.
StockTradeMatching.xlsx
If you have Excel 2016 on an Office 365 subscription with monthly updates, you now have dynamic arrays. I took advantage of that feature to align the buy and sell transactions of the different tickers.
StockTradeMatching.xlsx
StockTradeMatching.xlsx
Premium Content
You need an Expert Office subscription to comment.Start Free Trial