Hi,
I have a really long formula which makes reference to over 600 cells, which is above the 255 cell reference limit.
However, I'm not sure how to get around this by simplifying or splitting up the formula, without losing the embedded IF statements functionality.
I've attached an example workbook to show the layout that I am working with.
The formula I need help with is entered into column AF, with the desired outcome of outputting the second chronological combination of items.
Bookmarks