| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
change values in a column
i am looking for a way to be able to drag the information in a cell down a column keeping some information constant while changing others. For example: =IF($B$2=4,"4",IF($C$2=4,"4")) =IF($B$2=5,"5",IF($C$2=5,"5")) I would like to be able to have the following cells continue with the number sequence =IF($B$2=6,"6",IF($C$2=6,"6")) =IF($B$2=7,"7",IF($C$2=7,"7")) etc. thx -- thanx |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I change all negative values in a column to = 0? | Excel Worksheet Functions | |||
| How to find the largest change of values in a column | Excel Worksheet Functions | |||
| macro to change multiple values in a column | Excel Discussion (Misc queries) | |||
| Resetting values based on change in cells of other column | Excel Discussion (Misc queries) | |||
| Change all values in an excel column at once? | Excel Discussion (Misc queries) | |||
Threaded Mode
