You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Enginerd" wrote in message
...
Thanks!! I like your implementation.

"T. Valko" wrote:

I am thinking that there should be some kind of function
that will return the cell referance of the first cell in list
of cells that matches a certian criteria.

This will return the cell address of the first instance of 250 in the
range
A2:A1000:

=ADDRESS(MATCH(250,A2:A1000,0)+ROW(A2)-1,COLUMN(A1),4)

--
Biff
Microsoft Excel MVP


"Enginerd" wrote in message
...
I have a 3000 row table that has three columns: Time, Sensor1 and
Sensor2.

I need to break this table up into sub tables. I would like each sub
table
to contain the different blocks of when sensor 1 starts at value of 250
and
ends at 302.

I am thinking that there should be some kind of function that will
return
the cell referance of the first cell in list of cells that matches a
certian
criteria.

In my perfect world I would like to past in new raw data over the old
raw
data on the worksheet and have the sheet automatically adjust.


.