Hi,
In Row 1 am certain characters from A1 until BB1. And there, I have a certain character, say #, and I need a formula to count characters from row 1 to the # character in Row 2, and after that character to restart numbering from one to the next character # and so on until the BB1.
Let say that the row 1 is the # character in D1, F1 and K1
In row 2 beginning with A2, I want to show the following sequence of numbers: 1, 2, 3, #1, 1, #2, 1, 2, 3, 4, #3, 1, 2, 3 .... .
Thanks.