Hiding rows question. HELP!!!

  • Thread starter Thread starter John
  • Start date Start date
J

John

Hi. I was wondering if there was a way to program rows on
a worksheet to automatically hide themselves if no
information is put into them? I mean I am transferring
information from another sheet onto the sheet and then
averaging the scores. I want to hide the rows until
information is transferred into them through the VLOOKUP
function. That way the tests will be one after the other
and will be averaged. I'm sorry if this is in any way
confusing. Thanks for any help!
 
Either filter the data using Autofilter and choose greater than 0, or add another column and put a
formula in such as =IF(F1="","","Y") and thenf ilter that column on the Ys.

AVERAGE will not take into account blank cells, so as lomg as you use the correct function you
should be OK.

You should also investigate the SUBTOTAL function as this will only work on the visible cells if
you have filtered using Autofiilter or Advanced Filter. That function takes a number of
arguments, from 1 to 9 and will allow you to total / average etc depending on what you want from
your data.
 
Ok Plase excuse my ignorance on this :) I added a column
in column A that I titled "Trimester". On each of the 3
trimester sheets I have done this. If a test belongs in
the 1st trimester I put a 1, if in the second I put a 2,
3rd a 3. Where and how do I filter the sheet so that if
there is not a "1" in the trimester column on the 1st
trimester sheet, it will hide the row? Is there also a
way to format the sheet so that the rows will be hidden
until something is transferred over to that sheet? I'm
sorry if this is really confusing.

Either filter the data using Autofilter and choose
Click to expand...
greater than 0, or add another column and put a
formula in such as =IF(F1="","","Y") and thenf ilter that column on the Ys.

AVERAGE will not take into account blank cells, so as
Click to expand...
lomg as you use the correct function you
should be OK.

You should also investigate the SUBTOTAL function as
Click to expand...
this will only work on the visible cells if
you have filtered using Autofiilter or Advanced Filter.
Click to expand...
That function takes a number of
arguments, from 1 to 9 and will allow you to total /
Click to expand...
average etc depending on what you want from
 
No problem - Select the range of data in the column that has the 1,2,3 etc. Now do Data / Filter
/ Autofilter. You will now see a little dropdown arrow at the top of your column. Click on that
and select the 1 from the list - All other rows will be automatically hidden.
 
Thank you so much! That works great.
-----Original Message-----
No problem - Select the range of data in the column that
Click to expand...
has the 1,2,3 etc. Now do Data / Filter
/ Autofilter. You will now see a little dropdown arrow
Click to expand...
at the top of your column. Click on that
 
My pleasure - Glad you're sorted. There are other options in the filter if you hit custom that
may be of interest to you as well.
 
Back
Top