Hi - can anyone help me with an Excel 2003 question? I'm working with 3 cells:
a1 [format m/d/yyyy h:mm] - contents= 1/1/2010
b1 [format m/d/yyyy h:mm] - contents= null
c1 [format text] - contents "CLOSED"
All column & cell values are loaded in from a csv file. I can't [i.e. don't
want to] place a formula in cell b1 'cause I'll lose it on the next import,
so I'm trying to place a formula in a 4th cell [d1] that will a) see if c1
contains a value of "CLOSED", and b) if true, copy the date/time from a1
into b1. I've tried variations using IF and EXACT formulae & had no
success; e.g.
=IF(c1="CLOSED",b1=a1
=IF(c1="CLOSED",((VALUE(b1=a1))
Any suggestions on howto get it done? thanks!!!! - bob

Hi,
in B1 enter

=IF(c1="CLOSED",a1)

"Bob" wrote:

Hi - can anyone help me with an Excel 2003 question? I'm working with 3 cells:
a1 [format m/d/yyyy h:mm] - contents= 1/1/2010
b1 [format m/d/yyyy h:mm] - contents= null
c1 [format text] - contents "CLOSED"
All column & cell values are loaded in from a csv file. I can't [i.e. don't
want to] place a formula in cell b1 'cause I'll lose it on the next import,
so I'm trying to place a formula in a 4th cell [d1] that will a) see if c1
contains a value of "CLOSED", and b) if true, copy the date/time from a1
into b1. I've tried variations using IF and EXACT formulae & had no
success; e.g.
=IF(c1="CLOSED",b1=a1
=IF(c1="CLOSED",((VALUE(b1=a1))
Any suggestions on howto get it done? thanks!!!! - bob

since you don't want to put something in cell B1, would you consider having
one page be your input and another page be what you want?



"Eduardo" wrote:

Hi,
in B1 enter

=IF(c1="CLOSED",a1)

"Bob" wrote:

Hi - can anyone help me with an Excel 2003 question? I'm working with 3 cells:
a1 [format m/d/yyyy h:mm] - contents= 1/1/2010
b1 [format m/d/yyyy h:mm] - contents= null
c1 [format text] - contents "CLOSED"
All column & cell values are loaded in from a csv file. I can't [i.e. don't
want to] place a formula in cell b1 'cause I'll lose it on the next import,
so I'm trying to place a formula in a 4th cell [d1] that will a) see if c1
contains a value of "CLOSED", and b) if true, copy the date/time from a1
into b1. I've tried variations using IF and EXACT formulae & had no
success; e.g.
=IF(c1="CLOSED",b1=a1
=IF(c1="CLOSED",((VALUE(b1=a1))
Any suggestions on howto get it done? thanks!!!! - bob

Bob, if you are the same 'Bob' that was asking about setting up a workbook to
track account ranking based on months in/amount of arrears:
Bob, I have actually put together a couple of workbooks that I think pretty
much do what you are looking for based on your description of needs. If
you'd like to get them to examine, just contact me at (remove spaces)
Help From @ JLatham Site.com

In either case, pardon the interruption of this specific discussion.
Although I do agree with your assessment in another thread with same question
that a VBA solution is probably the way to go.


"Bob" wrote:

Hi - can anyone help me with an Excel 2003 question? I'm working with 3 cells:
a1 [format m/d/yyyy h:mm] - contents= 1/1/2010
b1 [format m/d/yyyy h:mm] - contents= null
c1 [format text] - contents "CLOSED"
All column & cell values are loaded in from a csv file. I can't [i.e. don't
want to] place a formula in cell b1 'cause I'll lose it on the next import,
so I'm trying to place a formula in a 4th cell [d1] that will a) see if c1
contains a value of "CLOSED", and b) if true, copy the date/time from a1
into b1. I've tried variations using IF and EXACT formulae & had no
success; e.g.
=IF(c1="CLOSED",b1=a1
=IF(c1="CLOSED",((VALUE(b1=a1))
Any suggestions on howto get it done? thanks!!!! - bob

Check your other post.

Bob wrote:

Hi - can anyone help me with an Excel 2003 question? I'm working with 3 cells:
a1 [format m/d/yyyy h:mm] - contents= 1/1/2010
b1 [format m/d/yyyy h:mm] - contents= null
c1 [format text] - contents "CLOSED"
All column & cell values are loaded in from a csv file. I can't [i.e. don't
want to] place a formula in cell b1 'cause I'll lose it on the next import,
so I'm trying to place a formula in a 4th cell [d1] that will a) see if c1
contains a value of "CLOSED", and b) if true, copy the date/time from a1
into b1. I've tried variations using IF and EXACT formulae & had no
success; e.g.
=IF(c1="CLOSED",b1=a1
=IF(c1="CLOSED",((VALUE(b1=a1))
Any suggestions on howto get it done? thanks!!!! - bob

--

Dave Peterson