How To Choose Every Third Row Of A Table

[papakos22]

HI!!!!!!!!!
I WOULD LIKE TO ASK IF THERE IS A COMAND OR MACRO THAT
ALLOWS ME TO CHOOSE EVERY THIRD ROW OF A TABLE WITH THOUSANDS ROWS

 

[Ken Wright]

Choose??? tell us what you need to do with every third row, as the answers
could well be different.

To add every 3rd value regardless of what row the data starts in

=SUMPRODUCT(--(MOD(ROW(A14:A37),3)=(MOD(ROW()+2,3))),A14:A37)

 

[Bob Phillips]

Sum every 3rd row is

=SUMPRODUCT(--(MOD(ROW(A14:A37),3)=1),(A14:A37))

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Choose??? tell us what you need to do with every third row, as the answers
could well be different.

To add every 3rd value regardless of what row the data starts in

=SUMPRODUCT(--(MOD(ROW(A14:A37),3)=(MOD(ROW()+2,3))),A14:A37)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

-------------------------------------------------------------------------- --
It's easier to beg forgiveness than ask permission
-------------------------------------------------------------------------- --

 

[David McRitchie]

I would expect use of Auto Filter based on Row number
http://www.mvps.org/dmcritchie/excel/sumdata.htm#autofilter

The easiest to include the 1st row which might have headers
would be
=MOD(ROW(),3)

Please don't use all capitals it is harder to read, Three or more
lines and it would be extremely hard to read.