Blank rows

[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

 

[Pete_UK]

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

 

[Bernard Liengme]

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

 

[brian.baker13]

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 -

Thankyou for your kind assistance, I will try tomorrow

 

[brian.baker13]

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 -

Cheers Pete,

Will try out tomorrow does look straightforward

 

[Pete_UK]

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