automatically updating a column in Excel 2007

[Guest]

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.

 

[Guest]

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

 

[Guest]

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...

 

[Guest]

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...

 

[Guest]

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

 

[Guest]

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.

 

[Guest]

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]

welcome, Arnold.

 

[Guest]

Hi, Max,

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

Thanks again,
Arnold

 

[Max]

Moments appreciated, Arnold.
Thanks.