LinkBack URL
About LinkBacks
Hi All
I'm looking for help to solve the following:-
I wish to select the data in every 4th colum i.e. A, D, H, L etc
How can I do this ?
Would really appreciate any help.
Thanks
Hi All
I'm looking for help to solve the following:-
I wish to select the data in every 4th colum i.e. A, D, H, L etc
How can I do this ?
Would really appreciate any help.
Thanks
Hi I'm no expert but I think you can do it by holding "Ctrl" and then clicking the column headers that you need.
Thanks but that won't work, too many columns...........
This should get you started. With the range starting in A1, this sums every 4th column with first summed column being column D so the columns be summed would be D, H, L etc. to column AZ
Formula:
Please Login or Register to view this content.
If your data starts in say column B
Formula:Please Login or Register to view this content.
Increase the -1 for every column displaced to the right. B being 1 C being 2 etc.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
Duplicate thread. See here:
http://www.excelforum.com/excel-gene...mn-or-row.html
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks