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

    Chronologically Number conditionally selected records using arrays

    Hi Chandoo Ninjas, I need help with a complex situation. I have tried many attempts but not helping!! I have a sheet (see attached) with the following columns: Sales Rep - contains names of sales reps Cust Name - contains names - not relevant to the problem Record ID - contains unique...
  2. O

    Sort unique distinct dates from a range of dates

    Hi, I have table (Excel Table) with a column of multiple dates. These are record creation dates. The range of dates is for a specified fiscal year. (say, April 1, 2013 to March 31, 2014) I want to make a list (for data validation) that will do the following: 1. Build an array of unique...
  3. O

    Dynamic Counting of Rows

    Hi, I have a growing database of Sales leads and I have to calculate their eligibility for incentives. Now the incentive plan is in "tiers". Meaning Lead 1 to 5 (chronologically by attended Date) is defined as Tier 1. Lead 6 to 10 is Tier 2. Each "Tier" has a different amount to be calculated...
Back
Top