Hide Rows Without Specifying the Row Numbers

[megalamchops]

Is it possible to to hide rows based on a cell value of N/A or Not Specified, but without specifying exactly the row number? N/A will always be in the same column and I just want to hide the row N/A is on and the next 3 rows following it. I have a long spreadsheet that is generated so its not the same every time. I don't think it's a good idea to manually specify hundreds of rows to hide.

 

[Joe4]

Which column are these values in?
Is the a text value of "N/A", or is it the "#N/A" error that Excel returns?

 

[megalamchops]

Hi Joe - the column would be J and is text value N/A. Thanks!

 

[megalamchops]

The rows hidden would be separated by an empty row (without any text in it) if that makes it easier.

ex.

 

[Rick Rothstein]

Is N/A the only text that will appear in Column J (as your example seems to be showing)?

And to be clear, you only want to hide that row, the one with N/A in it, and no other, correct?

 

[Joe4]

And to be clear, you only want to hide that row, the one with N/A in it, and no other, correct?

I just want to hide the row N/A is on and the next 3 rows following it.

 

[megalamchops]

Hi Rick - Other text may appear in column J, but only the ones with N/A would be hidden if that makes sense. I guess it complicates things. Thanks!

 

[Rick Rothstein]

@Joe4... I missed that.

@megalamchops... What is in Column J... constants or formulas?

 

[megalamchops]

They would be formulas. N/A is the result from a lookup.

 

[Joe4]

Is the a text value of "N/A", or is it the "#N/A" error that Excel returns?

Hi Joe - the column would be J and is text value N/A. Thanks!

They would be formulas. N/A is the result from a lookup.

If it is the result of a LOOKUP formula, then that IS actually the result of error that Excel is returning, and not a text value.
That is, unless you actually have the values of N/A in your lookup table, and it is returning that value, and not the #N/A error value it returns when it does not find a match.
So which one is it (it makes a very big difference in how we have to do this)?