I've attached a workbook which uses INDEX and MATCH on a list of trades that are sorted by date, newest date first. Each trade has two rows: The row which has the opening of the trade is always lower than the row which closes the trade.
To match the openings to closings I'm using an INDEX/MATCH formula. Once I have matched the openings to closings I can do further calculations.
The formula I'm using works for the first two rows of the trade history, but it fails on the third row and I can't figure out why. (The trade list must be sorted from newest to oldest, so the solution must take this into account)
Any thoughts to solve this?
Thanks!
Bookmarks