Conditional Overwrite

Why not just use Excel's MIN and MAX functions?

---

(How to) Upload a Workbook directly to the Forum
(please do not post pictures or links to worksheets)

• Click Advanced next to "Post Quick Reply" button at the bottom right of the editor box.
• Scroll down until you see "Manage Attachments",
• Click the "Choose" button at the upper left (upload from your computer).
• Select your file, click "open", click "upload"
• Once the upload is completed the file name will appear below the input boxes in this window.
• Close the Attachment Manager window.
• Click "Submit Reply"

Note: Please do not attach password protected workbooks/worksheets
Ensure to disable any Workbook Open/Autorun macros before attaching!

Example:
Column A________Column B______________Column C
-1__________________-1
-2__________________-2
-3__________________-3
+1_____________________________________+1
+2_____________________________________+2
+3_____________________________________+3


Overtime, Column A will change and become
Column A________Column B______________Column C
-10__________________ -1
-1 ___________________-2
-3___________________-3
+10_____________________________________+1
+1______________________________________+2
+30_____________________________________+3

so I want to copy values of column A and overwrite the values on column B if the value is less than
and overwrite values on C if the value is greater than, so i want to have

Column A________Column B______________Column C
-10__________________-10
-1___________________-2
-3___________________-30
+10_____________________________________+10
+1______________________________________+2
+30_____________________________________+30

Notice that the original value in column B (-2) and column C (+2) was no overwritten because it did not meet the condition.

How can I do this?

There are instructions at the top of the page explaining how to attach your sample workbook.

You can't. Just mark it solved.

Select Thread Tools from the menu link above and mark this thread as SOLVED.