Return cell referance of the first cell that equals a value?
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.
|