Is there a formula to move a cell up if text changes

mcfly · May 16th, 2002, 06:43 PM

Example:
IF cell b1 changed from "oh" to "s", this will change cell b11 to blank with this formula in b11 =if(b1="oh",b1,""). How can I make b12 move up to b11 like a sort, not leaving a space between cells. I also have the other letters(r,sub,ETC.) going to other areas of the spreadsheet organizing under certain areas. Please help me!!!!!!!!!

[ This Message was edited by: mcfly on 2002-05-16 17:44 ]

[ This Message was edited by: mcfly on 2002-05-16 17:46 ]

Juan Pablo González · May 16th, 2002, 07:10 PM

I'm not sure what you want... but, formulas can't modify the sheet "environment", they can only return a value.

You could have something like in B12

=IF(LEN(B11),B11,B10)

or something like that, but I'm not sure

mcfly · May 17th, 2002, 05:49 PM

Thanks for the reply but I did figure it out.

May 16th, 2002, 07:10 PM	#2
Juan Pablo González MrExcel MVP Join Date: Feb 2002 Location: Bogota, Colombia Posts: 11,927	I'm not sure what you want... but, formulas can't modify the sheet "environment", they can only return a value. You could have something like in B12 =IF(LEN(B11),B11,B10) or something like that, but I'm not sure __________________ Regards, Juan Pablo González http://www.juanpg.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 16th, 2002, 06:43 PM	#1
mcfly Board Regular Join Date: May 2002 Location: Davidson, NC Posts: 162	Example: IF cell b1 changed from "oh" to "s", this will change cell b11 to blank with this formula in b11 =if(b1="oh",b1,""). How can I make b12 move up to b11 like a sort, not leaving a space between cells. I also have the other letters(r,sub,ETC.) going to other areas of the spreadsheet organizing under certain areas. Please help me!!!!!!!!! [ This Message was edited by: mcfly on 2002-05-16 17:44 ] [ This Message was edited by: mcfly on 2002-05-16 17:46 ]

May 17th, 2002, 05:49 PM	#3
mcfly Board Regular Join Date: May 2002 Location: Davidson, NC Posts: 162	Thanks for the reply but I did figure it out.