Search results

Do you mean let the static data drive from a single Customer code? You are right--the static data can be reduced. I am not really concerned about the structure of that. The advice I am seeking is really about the most efficient way to capture the data across years. I think option number 2 it...

I didn't give you 500 lines (It would take awhile to anonymize/cleanse my current data for public consumption). The 2 tabs show the 2 strategies--both with the same data input across 2 forecast periods. In the add columns method, as the forecast period rolls, I would need to add columns to...

In each month, I would likely have 5k rows of data. There are about 15 columns of static data. The remaining columns contain the new monthly input. I didn't mention before that I am analyzing variation between forecast periods (or between the current forecast period and a budget). I would like...

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...

Thanks, Luke. That is perfect!

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...

Thanks, Sajan. I worked it out with several helper columns. I'll go back and try this!

How do you set up an if function to when you are trying to get in a range? For example, does this value fall in the range of 25-49?

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...

Not quite, but interesting. In the first column of my summary page, each cell references "Sheet1!A1", "Sheet2!A1" or "Sheet3!A1" (Except I actually have about 20 sheets with several entries). I want to easily change each A1 to C1 without editing each cell individually. There are several entries...

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...