Recent content by WarpathMechanic

NARAYANK: In response to #3, I have 75-100 charts. Honestly the problem was that even though I had the data configured for all the charts, That would mean that while the data is updated down the sheet, the charts were referencing the first set of data. This would mean rebuilding 72/75...

Apologies. Sales Office: 0000123456 This data would be used to create a chart. Q1 Q2 Q3 Q4 Total 2011 $69,307 $104,317 $80,642 $35,109 $289,375 2010 $174,325 $138,097 $281,717 $173,726 $767,865 2009 $114,269 $114,143 $75,310 $130,859 $434,581 2008 $72,545 $117,921 $207,223...

I thought this would be simple but due to excel's constant usage of absolute cell referencing it is causing me issues. Q1 Q2 Q3 Q4 Total 2011 $69,307 $104,317 $80,642 $35,109 $289,375 2010 $174,325 $138,097 $281,717 $173,726...

A thought. Since it can and will be printed. Can I use INDEX, MATCH, and COUNTIF on something like Sales Office to get the unique values out of the list, reference that to get a table of data using SUMIFS then reference that to get the charts then copy and paste for each sales office then set up...

Finally got a chance to get it on google docs. here is the link: https://docs.google.com/spreadsheet/ccc?key=0AviubZlnLY-4dDJ5ZFRmR1RlSjFuRmswWGxtU1dtZnc

Sorry for the late reply. My company has blocked every site except google docs and I am trying to get it fitted to GDocs standards. The report will be coming!

So here is my dilemma: I have to create both a print and a digital version of a yearly review. The digital one was easy enough (pivot tables, pivot charts, some data manipulation, all thanks to this site), however converting it easily to print has got me stumped. What I am trying to...

After hours of searching the excel bible that is Chandoo.org and racking my brain trying to figure this one out. My boss has finally cut me a curveball I just cant get through on my own. I turn to the senseis of rows and columns for guidance. Here is what I have: Location ID Location Name...

Mike86: Sweet cupping cakes it works...I have no idea how even with your explanation but it works. I just got into the office so I will play around with this for a bit and see if I can't break it down and learn a trick or two. Luke M and Mike86, Thanks for all your help. Its really...

Luke, you are truly an asset. I set up the table as you said and it works wonderfully...but only for the specified dates. This field (B2) is going to be a data entry field for any date in the past. So these dates in the table need to show ranges such as: TODAY() and TODAY()-45 TODAY()-46...

Luke M: I thought as much. I placed your formula into my worksheet and it changes based on the value of B8 (Product Amount) but it does not seem to be changing when I modify the date field (B2). Any ideas why? I thought of building a table but ran into logistics issues with the Product...

Long time reader, HUGE fan of the site, First time poster: Here is my dilemma. I have a date input cell (B2), and a Face Value for a product (B8). I need to calculate three different date ranges Less than 45 days 45 days to 11 months 11 or more months It also makes a difference whether...