I am trying to index a series of arrays in which some products have index numbers and some not. Where index numbers exist, I need to keep these and just give the unindexed products the next reference number. The attached workbook has some examples which might explain it a bit better.
Grateful any help - it appears this cannot be resolved formulaically.
Bookmarks