| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula to hide row
I'm trying to write an IF formula referencing a cell (in the row) that is a 1
or 0; =if(cell=0,"no","yes"). If the cell is 1 (yes) I want to hide the row. Any suggestions? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formula to hide row
On 18 May, 22:09, sdwhite wrote:
I'm trying to write an IF formula referencing a cell (in the row) that is a 1 or 0; =if(cell=0,"no","yes"). If the cell is 1 (yes) I want to hide the row. Any suggestions? Hi sdwhite Use Data Filter AutoFilter on the column containing your 1s. Drop down the filter button and select (Custom...) Choose "does not equal" from the first list and enter 1 in the next field. Regards Steve |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formula to hide row
Formulas can do nothing but return a result to the cell in which they reside.
To hide the row would require filtering or event code. Gord Dibben MS Excel MVP On Fri, 18 May 2007 14:09:02 -0700, sdwhite wrote: I'm trying to write an IF formula referencing a cell (in the row) that is a 1 or 0; =if(cell=0,"no","yes"). If the cell is 1 (yes) I want to hide the row. Any suggestions? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula won't hide | Excel Discussion (Misc queries) | |||
| Hide formula | New Users to Excel | |||
| Hide Formula | Excel Discussion (Misc queries) | |||
| how to hide the formula | Excel Worksheet Functions | |||
| Hide formula | Excel Worksheet Functions | |||
Hybrid Mode
