Formula for Hide a Row

YroxMk · #1 05-26-2016, 02:31 AM

Hi,

I Need to do a formula for hide a row that contains Minus(-) values. Please help for this, Well I show you an example.

Column 01 Column 02
Charts 200
Bank 800
Apple -100
Orange -20
Sharp 50

What i need to do is a formula (not VBA) to select minus(-) values and hide that entire row.

Thank you.

xor · #2 05-26-2016, 03:18 AM

You can't do that by formula, but you can use Auto Filter, column B, Number Filters, Greater Than 0.

YroxMk · #3 05-26-2016, 03:31 AM

I tried it, It's Working, Thank you

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Need help with dragging a formula and changing a reference column as I drag the formula.	LupeB	Excel	1	10-22-2015 03:02 PM
How to Hide/Un-hide a worksheet based on cell on another sheet.	easton11	Excel Programming	1	06-02-2015 12:07 PM
Formula to hide '0' from blank referenced cells	formuladummy	Excel	3	05-08-2014 02:33 AM
how to hide other recipients?	gerryb	Outlook	2	08-12-2009 09:56 AM
Hide a combo box	DrewB	Word	3	06-08-2009 11:29 PM