Hi,
I have attached a sheet with a column highlighted in green.
The column has "OPEN" & "CLOSE" text which is derived from an existing formula.
Is their a way to tag these "OPEN" & "CLOSE" from the top going down so they appear as follows:
OPEN-1, OPEN-2, OPEN-3 etc
CLOSE-1, CLOSE-2, CLOSE-3 etc.
I want to analyse what is occurring between "OPEN-1" & "CLOSE-1" so need a way of identifying them.
Thanks
Bookmarks