Hi FDibbins,
I somewhat understand what your formula is doing, but I don't understand how to apply it with Melvinrobb's solution. You indicate to copy down the formula you provided, but where and what other fields would reference the column where this is copied down? From my perspective, your code/formula would have to be part of Melvinrobb's IF statement to get what I'm hoping to retrieve.
I hope I'm making sense...
Bookmarks