View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default 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.