Interested in your thoughts on this.
On a monthly basis I aggregate forecast data for a rolling 12 month period. I am trying to arrive at a data format suits this activity. For simplicity's sake, lets say there is static data (e.g. ustomer name, market, product) and dynamic data (e.g. monthly...
I have 2 lists of numbers 1,3,5 and 2,4,6. If the value in a cell contains a number from list 1, I want value x returned. If the value contains a number from list 2, I want value y returned.
In reality my 2 lists are huge. I know this can be done with an array formula of some sort, but I can't...
In each of 5 columns of data there is a different unit sell price that is based on a quantity discount. The discount buckets are 1-24, 25-49, 50-199, 200-999 and 1000+.
In another column is the quantity. I want to calculate an extended price (quantity * sell price) that is accurate based on...
I have a huge list (60k+ lines ) in one sheet. I have a smaller list on another sheet. Most of the short list items are the huge list. I know I can copy the short list lines over, sort and highlight duplicates. That seems clunky.
What is the best way to remove all of the short list items from...
I have a series of data in which all cells point to a value in other sheets (e.g. Sheet A is summary page and sheets 1, 2 & 3 are the source). How can I create a corresponding series of data that point to the same place, but in a different column. So if the first row of data point to A1 on...
My fiscal year is December to November. I have a set of sales data in a chart. The first column is the last day of each month. So A2 (there is a header row) is 12/31/08 and A37 is 11/31/10.
Can I filter this data set by my fiscal years without checking off the months manually in the nested...
I am fairly new to camera tool, but I have searched this forum, Chandoo's posts and scoured the web to figure out my problem(s).
In Excel 2007 (which I use at work) the picture of the chart becomes distorted, text is choppy and the chart lines get thicker. It's like a photocopy of a...
I have a line chart that projects cash flow. I want to automatically add a vertical line on the chart simply indicating the current day/period in the chart? Is that possible without crazy VBA magic?
Is there a way to duplicate any of the functionality in the new google charting options in Excel?
see here: http://www.youtube.com/watch?v=70O0RQhuiSI&feature=player_embedded
The dynamic timeline slider is pretty slick.
Here is the whole post...