Blank rows

  • Thread starter Thread starter brian.baker13
  • Start date Start date
B

brian.baker13

Hi

I have a summary table looking at rows in another table

i.e.
=a13,=a14,=a15 etc etc

When the corresponding cells are empty I am left with blank rows on my
summary table.

Is there any way of eliminating the row automaticall when a blank cell
is looked up. Thus will straighten my summary table up and reduce the
blank rows so I only have those with data in showing?

Thanks

Brian
 
Apply a filter to the column returning data - select non-blanks from
the filter pull-down (or if these are numbers select Custom | Not
equal to | 0), and this will display only those rows with data in
them.

Hope this helps.

Pete
 
Let's say your summary table starts in G1 (adjust as needed)
In H1 enter the text A13; in H2 the text A14, and so on
In G1 =INDIRECT(H1) and copy down as far as needed
In I1 enter =--ISBLANK(INDIRECT(H1) and copy down the column as needed
Let's say the last row is 20
Now sort G1:I20 by column I
Now all you numbers are at the top and zeros (from blank cells) are at the
bottom
Delete row that are not required.
best wishes
 
Let's say your summary table starts in G1 (adjust as needed)
In H1 enter the text A13; in H2 the text A14, and so on
In G1 =INDIRECT(H1) and copy down as far as needed
In I1 enter =--ISBLANK(INDIRECT(H1) and copy down the column as needed
Let's say the last row is 20
Now sort G1:I20 by column I
Now all you numbers are at the top and zeros (from blank cells) are at the
bottom
Delete row that are not required.
best wishes
--
Bernard V Liengme
Microsoft Excel MVPwww.stfx.ca/people/bliengme
remove caps from email










- Show quoted text -
Click to expand...

Thankyou for your kind assistance, I will try tomorrow
 
Apply a filter to the column returning data - select non-blanks from
the filter pull-down (or if these are numbers select Custom | Not
equal to | 0), and this will display only those rows with data in
them.

Hope this helps.

Pete







- Show quoted text -
Click to expand...

Cheers Pete,

Will try out tomorrow does look straightforward
 
Thanks for feeding back, Brian.

I use the method all the time, where I can have a reporting sheet with
all categories listed, and then each month if there is nothing for a
particular category the filter hides it and the table bunches up
accordingly for the print-out. Next month I re-apply the filter.

Pete
 
Back
Top