• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Recent content by ellistyle

  1. E

    Data Structure Best Practice

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

    Data Structure Best Practice

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

    Data Structure Best Practice

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

    Data Structure Best Practice

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

    Return a different value depending on which List a corresponding value is from.

    Thanks, Luke. That is perfect!
  6. E

    Return a different value depending on which List a corresponding value is from.

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

    Variable Multiplier Based on a Value in another Column

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

    Variable Multiplier Based on a Value in another Column

    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?
  9. E

    Variable Multiplier Based on a Value in another Column

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

    Find and Remove Duplicates from 2 Lists

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

    Replace a similar cell reference across multiple cells

    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...
See more
Back
Top