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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
change values in a column
Try it like this:
=IF($B$2=ROW(A4),""&ROW(A4),IF($C$2=ROW(A4),""&ROW (A4))) and copy it down. You do not specify what to do if neither B2 nor C2 = 4 (in your first formula). Hope this helps. Pete On Apr 21, 10:25*pm, dmack wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
change values in a column
=IF($B$4=ROW(A6),6,400)
or =IF(OR($B$4=ROW(a6),$C$4=ROW(a6)),6,900) -- Don Guillett Microsoft MVP Excel SalesAid Software "dmack" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
change values in a column
Try this in the starting cell, say in D2:
=IF($B$2=ROWS($1:1)+2,ROWS($1:1)+2,IF($C$2=ROWS($1 :1)+2,ROWS($1:1)+2,"")) Copy down -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "dmack" wrote: 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 |
Reply |
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) |