ExcelBanter - formula to hide row

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - formula to hide row (https://www.excelbanter.com/excel-worksheet-functions/143338-formula-hide-row.html)

sdwhite

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?

Scoops

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

Gord Dibben

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?

All times are GMT +1. The time now is 04:22 AM.