How to Hide/Unhide empty rows with formula based on criteria in G3?

LearnerExcel · #1 02-14-2018, 11:53 PM

How to Hide/Unhide empty rows (with formula inside the Cells) based on criteria in G3?

Please find attached the Excel files for reference.

Note: This is required for one of my friends who doesn't know much about MS Office.

NoSparks · #2 02-15-2018, 07:17 AM

Have a look at the video here for an understanding of how advanced filter works.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
VBA - Deleting Rows (criteria based)	BobbyG	Project	1	07-31-2017 08:55 AM
Hide Rows that are empty inserted by Quick parts.	Anto_bt	Word	6	12-15-2015 05:15 PM
Hide / unhide Rows	NullVBA	Excel Programming	4	12-09-2015 05:10 AM
Hide/Unhide Text Based on Drop Down Selection	gw1500se	Word	3	02-19-2015 12:17 PM
Hide/Unhide a Block of Text Based on Choice Selection	inquirer	Word VBA	7	09-22-2014 04:41 PM