Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Moving Cell Values
How can I get excel to separate cell values based on some form of conditional
statement? Such that entering a code such as 9999 in one cell will cause the value of another cell to shift into a different column. I am trying to distinguish between billable and non billable time. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Moving Cell Values
Just use an extra cell (cells are cheap). Say if A1 is 9999 we want 13 to
appear in column C, otherwise 13 should appear in column D. 1. put 13 in B1 2. put =IF(A1=9999,B1,"") in C1 3. put =IF(A1=9999,"",B1) in D1 The 13 will move depending on whether you put 9999 in A1 or some other walue in A1. -- Gary''s Student - gsnu200763 "regdor" wrote: How can I get excel to separate cell values based on some form of conditional statement? Such that entering a code such as 9999 in one cell will cause the value of another cell to shift into a different column. I am trying to distinguish between billable and non billable time. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Moving values from one colum to another when there is spaces betwe | Excel Worksheet Functions | |||
moving values only | Excel Discussion (Misc queries) | |||
moving x column values into x row values | Excel Worksheet Functions | |||
moving values from sheet to another | Excel Discussion (Misc queries) | |||
moving values from one sheet to another | Excel Discussion (Misc queries) |