LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
amc422
 
Posts: n/a
Default

Yes, however it won't always be A1 and B1... the row will advance by at least
one every day. So it would be A1 and B1 today; A2 and B2 tomorrow; possibly
A5 and B5 the following day (as more than one row of data could be added in a
given day).

Also, please note my last post with an additional condition.

Can this be done?

Thanks,
Anna

"Aladin Akyurek" wrote:


If A1 houses a number and B1 is empty, return the last numerical value
that is in C. Is this what you want?

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



--
Aladin Akyurek
------------------------------------------------------------------------
Aladin Akyurek's Profile: http://www.excelforum.com/member.php...fo&userid=4165
View this thread: http://www.excelforum.com/showthread...hreadid=278034


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Delete Cell Value Based on Another Cell T or F DocuMike Excel Discussion (Misc queries) 3 January 5th 05 08:46 PM
View and Cell Sum Range Dewayne Excel Discussion (Misc queries) 4 December 29th 04 03:23 PM
make a cell empty based on condition mpierre Charts and Charting in Excel 2 December 29th 04 01:01 PM
returning a text cell based on a number cell Josh7777777 Excel Worksheet Functions 2 November 2nd 04 07:42 PM
How to populate column with formula based on value in cell Cameron Stewart Excel Worksheet Functions 2 November 2nd 04 01:36 AM


All times are GMT +1. The time now is 12:07 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"