automatically updating a column in Excel 2007
 

I would like to automatically update a column based upon information entered
in another column. Specifically, entering information into cells in, for
example, column A, have Excel find the exact match for an entry in column B,
& in that same row update the cell in column C with some pre-defined
information.
--
Thank you, Arnold

automatically updating a column in Excel 2007
 

One way

Put in C1:
=IF(ISNUMBER(MATCH(B1,A:A,0)),"Yes","")
Copy down to the last row of data in col B, to return required results.

Replace "Yes" with the pre-defined info that you want inserted
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Arnold" wrote:
I would like to automatically update a column based upon information entered
in another column. Specifically, entering information into cells in, for
example, column A, have Excel find the exact match for an entry in column B,
& in that same row update the cell in column C with some pre-defined
information.
--
Thank you, Arnold

automatically updating a column in Excel 2007
 

I do believe your suggestion will work. I've been thinking "forward" rather
than "reverse".

Each row is an account's information. Column A will have entered a 4-digit
number, an account number, indicating an account has been updated. Column B
contains the actual 4-digit account number for each row's account. Column C
contains the date the account was last updated. Entering your statement into
column C directs it to check its value in column B with the values in column
A &, if it finds a match in column A, then update its value in column C with
"x", otherwise leave blank. However, rather than leaving column C blank, I'd
rather leave the value already there intact. I can accomplish this by...
--
Thank you, Arnold


"Max" wrote:

One way

Put in C1:
=IF(ISNUMBER(MATCH(B1,A:A,0)),"Yes","")
Copy down to the last row of data in col B, to return required results.

Replace "Yes" with the pre-defined info that you want inserted
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Arnold" wrote:
I would like to automatically update a column based upon information entered
in another column. Specifically, entering information into cells in, for
example, column A, have Excel find the exact match for an entry in column B,
& in that same row update the cell in column C with some pre-defined
information.
--
Thank you, Arnold

automatically updating a column in Excel 2007
 

I do believe your suggestion will work. I've been thinking "forward" rather
than "reverse".

Each row is an account's information. Column A will have entered a 4-digit
number, an account number, indicating an account has been updated. Column B
contains the actual 4-digit account number for each row's account. Column C
contains the date the account was last updated. Entering your statement into
column C directs it to check its value in column B with the values in column
A &, if it finds a match in column A, then update its value in column C with
"x", otherwise leave blank. However, rather than leaving column C blank, I'd
rather leave the value already there intact. I can accomplish this by...
--
Thank you, Arnold


"Max" wrote:

One way

Put in C1:
=IF(ISNUMBER(MATCH(B1,A:A,0)),"Yes","")
Copy down to the last row of data in col B, to return required results.

Replace "Yes" with the pre-defined info that you want inserted
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Arnold" wrote:
I would like to automatically update a column based upon information entered
in another column. Specifically, entering information into cells in, for
example, column A, have Excel find the exact match for an entry in column B,
& in that same row update the cell in column C with some pre-defined
information.
--
Thank you, Arnold

automatically updating a column in Excel 2007
 

I should also note, the "numbers" in columns A & B are formatted as text,
because many start with a zero. Thanks again.

"Max" wrote:

One way

Put in C1:
=IF(ISNUMBER(MATCH(B1,A:A,0)),"Yes","")
Copy down to the last row of data in col B, to return required results.

Replace "Yes" with the pre-defined info that you want inserted
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Arnold" wrote:
I would like to automatically update a column based upon information entered
in another column. Specifically, entering information into cells in, for
example, column A, have Excel find the exact match for an entry in column B,
& in that same row update the cell in column C with some pre-defined
information.
--
Thank you, Arnold

automatically updating a column in Excel 2007
 

Ref your elaborations. Try inserting a new col D for the revised formula
below. Format col D as date. I'll presume you want the current date (ie
today's date) to be returned where the acc no. in B1 is found within the
"updated" list of acc nos in col A. If the acc no. is not found, then to
return its existing value (ie the previous date) in col C, if there is any.
And if there is no existing date in col C, to return a blank: "" (you didn't
mention this possibility, but I'm catering for it).

Put in D1:
=IF(ISNUMBER(MATCH(B1,A:A,0)),TODAY(),IF(C1="","", C1))
Copy down to the last row of data in col B. Select col D, kill the formulas
with an "in-place" copy n paste special as values. Then delete col C. The
"new" col C (ie the ex-col D) is your update for the day. Just repeat the
process at the end of each day.

Pl click the "Yes" button from where you're reading this,
if this post was helpful to you.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Arnold" wrote in message
...
I should also note, the "numbers" in columns A & B are formatted as text,
because many start with a zero. Thanks again.

I do believe your suggestion will work. I've been thinking "forward" rather
than "reverse".

Each row is an account's information. Column A will have entered a 4-digit
number, an account number, indicating an account has been updated. Column B
contains the actual 4-digit account number for each row's account. Column C
contains the date the account was last updated. Entering your statement into
column C directs it to check its value in column B with the values in column
A &, if it finds a match in column A, then update its value in column C with
"x", otherwise leave blank. However, rather than leaving column C blank, I'd
rather leave the value already there intact. I can accomplish this by...

automatically updating a column in Excel 2007
 

Yes, this new formula covers all the bases. With regards to TODAY(), if I
wanted another date, I could type "10/1/07", for example, to have it
inserted. Yes, this seems to have it. Thank you very much, Max.

"Max" wrote:

Ref your elaborations. Try inserting a new col D for the revised formula
below. Format col D as date. I'll presume you want the current date (ie
today's date) to be returned where the acc no. in B1 is found within the
"updated" list of acc nos in col A. If the acc no. is not found, then to
return its existing value (ie the previous date) in col C, if there is any.
And if there is no existing date in col C, to return a blank: "" (you didn't
mention this possibility, but I'm catering for it).

Put in D1:
=IF(ISNUMBER(MATCH(B1,A:A,0)),TODAY(),IF(C1="","", C1))
Copy down to the last row of data in col B. Select col D, kill the formulas
with an "in-place" copy n paste special as values. Then delete col C. The
"new" col C (ie the ex-col D) is your update for the day. Just repeat the
process at the end of each day.

Pl click the "Yes" button from where you're reading this,
if this post was helpful to you.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Arnold" wrote in message
...
I should also note, the "numbers" in columns A & B are formatted as text,
because many start with a zero. Thanks again.

I do believe your suggestion will work. I've been thinking "forward" rather
than "reverse".

Each row is an account's information. Column A will have entered a 4-digit
number, an account number, indicating an account has been updated. Column B
contains the actual 4-digit account number for each row's account. Column C
contains the date the account was last updated. Entering your statement into
column C directs it to check its value in column B with the values in column
A &, if it finds a match in column A, then update its value in column C with
"x", otherwise leave blank. However, rather than leaving column C blank, I'd
rather leave the value already there intact. I can accomplish this by...

automatically updating a column in Excel 2007
 

welcome, Arnold.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Arnold" wrote in message
...
Yes, this new formula covers all the bases. With regards to TODAY(), if I
wanted another date, I could type "10/1/07", for example, to have it
inserted. Yes, this seems to have it. Thank you very much, Max.

automatically updating a column in Excel 2007
 

Hi, Max,

Wanted to take a moment to thank you. Your suggestion works like a charm!
Absolutely handles the situation.

Thanks again,
Arnold


"Max" wrote:

welcome, Arnold.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Arnold" wrote in message
...
Yes, this new formula covers all the bases. With regards to TODAY(), if I
wanted another date, I could type "10/1/07", for example, to have it
inserted. Yes, this seems to have it. Thank you very much, Max.

automatically updating a column in Excel 2007
 

Moments appreciated, Arnold.
Thanks.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Arnold" wrote in message
...
Hi, Max,

Wanted to take a moment to thank you. Your suggestion works like a charm!
Absolutely handles the situation.

Thanks again,
Arnold