Posted to microsoft.public.excel.worksheet.functions

Scoops

external usenet poster

Posts: 108

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formula won't hide	Karen	Excel Discussion (Misc queries)	1	March 19th 07 09:46 PM
Hide formula	Anand vijay	New Users to Excel	2	January 6th 07 01:11 PM
Hide Formula	BAIJU	Excel Discussion (Misc queries)	3	July 16th 06 08:00 AM
how to hide the formula	Thomas	Excel Worksheet Functions	1	October 27th 05 06:28 AM
Hide formula	skateblade	Excel Worksheet Functions	10	October 15th 05 08:36 PM

All times are GMT +1. The time now is 06:56 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us