Haven't figured that one out myself.

Copied from Debra's site and use it all the time but I'm thick as a post when it
comes to formulas.

Hang in there. Biff or someone will explain it to us..


Gord

On Fri, 23 May 2008 17:19:46 +0100, Nozza wrote:

In article , Gord Dibben
said...

Noz

=MOD(SUBTOTAL(3,$A1:$A$2),2)=0

This one will retain the banding when you filter the data.

=MOD(ROW(),2)=0 will not retain the banding through filtering.


Gord Dibben MS Excel MVP


Gord

Thanks for posting this - I have used it - and as you say it works
even when filtering. Brilliant!

But my question now is how does this work?

I understand the MOD, but what is the subtotal bit actually doing? I
know that the 3 is the function reference number for COUNTA, which
does a count if present...

Just curious that's all - as I like to know why something that works,
works! :)

Noz