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

Search results

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. E

    Replace a similar cell reference across multiple cells

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

    Date Filtering with Charts

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

    Camera Tool with Charts

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

    Add a Vertical Marker in a Line Chart Indicating todays date

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

    New Google Docs Dynamic Charts

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