Hello,
I'm using CELL with INDEX/MATCH to find the next occurrence of the word "end" in a column. The problem is it only returns the address of the first occurrence and that's it.
How can I find the address the next occurrence of the word "end", then the next and so on?
Any help much appreciated as I'm not coping. (I have autism and learning difficulties so get upset when I feel stupid. My apologies.)
Thank you,
AnyaK
I'm using CELL with INDEX/MATCH to find the next occurrence of the word "end" in a column. The problem is it only returns the address of the first occurrence and that's it.
How can I find the address the next occurrence of the word "end", then the next and so on?
Any help much appreciated as I'm not coping. (I have autism and learning difficulties so get upset when I feel stupid. My apologies.)
Thank you,
AnyaK