Antsmarching.org Forums - Dave Matthews Band Discussion - View Single Post - Roger’s Excel Thread
View Single Post
Old 02-17-2017, 10:10 AM   #129
daveshookme
Altuve wore a wire
 
daveshookme's Avatar
 
Join Date: Jun 2009
Location: Supreme Courtyard by Marriott
Posts: 62,665

Shows Seen: 54

DMB Hub Stubs: 20

My Tour Central Stats

Re: Excel Help

Quote:
Originally Posted by rconverse View Post
There's really no need for a new named range.

In the spreadsheet that you sent me, you have the following formula:



You can use this formula. The only thing you'll need to change is in bold.



Feb will be H2, Mar will be O2, etc...
No there really is no need for it. One of the joys in this project is it's just a learning thing for me, overcomplicating things just to learn new functions, logic my way through new problems/find alternative or easier ways to solve something, etc.

I was learning how to dynamically name ranges using the offset function. It's not a huge deal, I figured it that part out. It just wasn't working with the sum. No big deal.
__________________
Tape Cover Artwork
daveshookme is offline   Reply With Quote