Log in or Sign up

You are viewing our forum as a guest. For full access please Register. WindowsBBS.com is completely free, paid for by advertisers and donations.

Summing every other row in Excel

Discussion in 'Other PC Software' started by tylerho, 2008/06/13.

2008/06/13

tylerho Inactive Thread Starter

Joined:

2008/02/26

Messages:

87

Likes Received:

0

Is there a way to select every other row in a pivot table in Excel 2003? I could do it manually but it would take forever as this pivot table is huge. Thank you.

tylerho,

#1
2008/06/14

Bilb0 Inactive

Joined:

2007/07/23

Messages:

203

Likes Received:

6

Are you sure it is exactly every other row?

If so, are you sure you cannot filter the Pivot Table by some means to eliminate the unwanted results?

If nothing else, you could use the concatenate function to build some VBA and use the Range().Select method.

Let me know if you're not familiar with this and I'll write a little snippet for you. Specify the columns and rows.

If you feel that a user has helped you with your question, please remember to add to their reputation by clicking on the "Add to (user's) Reputation" icon for the post(s) that helped you.

Bilb0,

#2
Log in or Sign up to hide this advert.

(You must log in or sign up to reply here.)

Share This Page

This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.

Accept Learn More...