We help IT Professionals succeed at work.

Excel index/match/sumproduct formula help

newparadigmz
newparadigmz asked
on
formula.PNG
what is the formula to populate the yellow cells?
Comment
Watch Question

Mechanical Engineer
Most Valuable Expert 2013
Top Expert 2013
Commented:
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
byundtMechanical Engineer
Most Valuable Expert 2013
Top Expert 2013

Commented:
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

Author

Commented:
totally worked! Thanks

don't have the newer excels though.

but i need to go a few levels deeper, which I posted in a new question....