Prev: To Display Negative Dates
Next: calculations or macros?
From: LisaK on 9 Sep 2009 15:44
is it possible to auto add a blank row based on criteria in 3 adjacent
columns? the data is sorted based on these 3 columns, but we don't need
subtotals, just blank rows. Thank you.
From: Dave Peterson on 9 Sep 2009 16:39
I'd add an extra column and concatenate those 3 fields.

=a2&"..."&b2&"..."&c2
And drag done

Then use that column when I do data|subtotal.

If I didn't want the subtotals, I'd use count (it's always useful <bg>). Or
just use the outlining symbols on the left, hide the details and clear the
contents of the subtotal rows.

You may want to hide the details
select the range to clear
Hit F5 (edit|goto or ctrl-g)
Special|visible cells only
then clear those visible cells.

(Especially with xl2007.)

LisaK wrote:
>
> is it possible to auto add a blank row based on criteria in 3 adjacent
> columns? the data is sorted based on these 3 columns, but we don't need
> subtotals, just blank rows. Thank you.

--

Dave Peterson
From: Gord Dibben on 9 Sep 2009 17:18
Your subject reads add blank columns.

Your description reads blank row.

Which do you want and what are the 3 criteria?

From your description I'm not clear on your layout.

VBA is required to add a blank row or column.


Gord Dibben MS Excel MVP

On Wed, 9 Sep 2009 12:44:36 -0700, LisaK <LisaK(a)discussions.microsoft.com>
wrote:

>is it possible to auto add a blank row based on criteria in 3 adjacent
>columns? the data is sorted based on these 3 columns, but we don't need
>subtotals, just blank rows. Thank you.

 | 
Pages: 1
Prev: To Display Negative Dates
Next: calculations or macros?