Hi all,
I have the next problem. In column A are 5000 rows of data. Between these data is are a number of cells that looks like [testx] where the x is a number from 0 to 999. What I need to know is the maximum x.
Example:
a
s
d
[test0]
f
d
s
[test1]
t
[test2]
w
w
So the result should be x = 2.
Thanks
JH
I have the next problem. In column A are 5000 rows of data. Between these data is are a number of cells that looks like [testx] where the x is a number from 0 to 999. What I need to know is the maximum x.
Example:
a
s
d
[test0]
f
d
s
[test1]
t
[test2]
w
w
So the result should be x = 2.
Thanks
JH