Hi,
I have attached my Spread Sheet and trimmed it down to just the problem i have.
In Column C i have Data which i import from a Web Page,
In Column K i have an OFFSET formula that looks for the text "NR:" in Column C and Displays this in the Column the same Row down its shown in Column C,
In Column I i have an INDEX/MATCH formula that displays the row BELOW the Cell containing "NR:" in Column C. It does this by using Column I as a helper Column and i need it to continue to work the same way if at all possible.
The problem i have and as you can see from the attachment is that Cells containing 2 consecutive identical letter below the cell NR: in Column C are not been returned in Column I like all the rest.
How can i fix this issue?
Thanks guys, hope you can help
Bookmarks