| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to retain last number in a cell
Sandeep,
Please send new email with attachments as recently sent - system with your email address and those files crashed and I do not have access to them now. These are the 3 messages you sent on 9/9/2008 Thank You JLatham (HelpFrom @ Jlathamsite.com) "Sandeep Himatsingka" wrote: In R1C3, I fill manually 1 or delete this 1 (i.e. blank). Only 2 actions in R1C3. In R1C2, I fill,say, number 30 then overwrite 30 with say 57 then overwrite 57 with 807 & so on. R1C2 is being filled regularly manually by me with different numbers. I want in R1C1 same number of R1C2 as long as R1C3 contains 1. The moment I delete 1 from R1C3 (make it blank), I want R1C1 should retain the last number (which it should have been copying thr' an excel formula) from R1C2 & STOP further copying same number from R1C2 unless R1C3=1. How to do it? Pls give the formula in R1C1???? Many thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change number of decimals but retain original style | Excel Discussion (Misc queries) | |||
| How delete formula bar and retain the computed number in a cell? | Excel Worksheet Functions | |||
| How do I retain a zero as the first number in a postal code? | Excel Discussion (Misc queries) | |||
| Add two cell values, retain it, and add another value | Excel Worksheet Functions | |||
| retain leading zeros in number format | Excel Discussion (Misc queries) | |||
Threaded Mode
