View Single Post
  #5   Report Post  
Domenic
 
Posts: n/a
Default


I'm not sure if this is what you're looking for, but try the
following...

If the values in Column C are text...

D1:

=MAX(IF((ISNUMBER(A2:INDEX(A:A,MATCH(REPT("z",255) ,C:C))))*(B2:INDEX(B:B,MATCH(REPT("z",255),C:C))=" "),ROW(A2:INDEX(A:A,MATCH(REPT("z",255),C:C))) ))

E1:

=IF(N(D1),INDEX(C:C,D1),"")

If the values in Colum C are numerical...

D1:

=MAX(IF((ISNUMBER(A2:INDEX(A:A,MATCH(9.99999999999 999E+307,C:C))))*(B2:INDEX(B:B,MATCH(9.99999999999 999E+307,C:C))=""),ROW(A2:INDEX(A:A,MATCH(9.999999 99999999E+307,C:C)))))

E1:

=IF(N(D1),INDEX(C:C,D1),"")

Hope this helps!

amc422 Wrote:
I am trying to return a value to a cell based on specified conditions in
a
range that increases every day by one or more rows. I want return the
value
of a cell which will positionally change daily (but will always be in
the
same column) as new data is entered (and likely be the last cell of
the
active spreadsheet) to another cell which will remain constant.

To illustrate:

Column A Column B Column C
Row 1

Row 2
Row3
Row4
Ect...

I know I need to use conditional logic, but can't get the syntax. I
want
the value in Column C returned to another defined cell if the
following
conditions are met:

There is numerical data in column A
AND
There is no data in column B

But here's the rub (for me): it must be the value of the last "active"
cell
in column C which meets the specified conditions. Since a new row(s)
of data
is entered to the spreadsheet on a daily basis, the row of the last
active
cell is is always advancing.

Hope this makes sense.

Can someone please help me?

Thanks in advance,
Anna



--
Domenic
------------------------------------------------------------------------
Domenic's Profile: http://www.excelforum.com/member.php...o&userid=10785
View this thread: http://www.excelforum.com/showthread...hreadid=278034