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

    Match/Index problem

    I am having a problem with Match/Index results. In my first set of data, I was able to pull all the data that matched 2 criteria using Match/Index with out any problem using this formula, (Each data entry was unique.) =INDEX(DATA1,MATCH(DATA2,IF(RANGE1=DATA, RANGE2),0),1) However, my...
  2. C

    Data sorting by order of appearance

    I have a file with 6,000 rows of data and several columns. Data has product numbers and dates with time stamps. A product may appear several times during a day worth of data. My goal is to sort the data by day, but I need to show the order that the products appear on the list (For example, out...
  3. C

    Modify dynamic range for chart

    I want to create a scroll bar for a dynamic chart. The dynamic chart only uses the last 7 columns of the dynamic table. When creating the ranges' X and Y names, I could not make this equation grab the last 7 columns only, =OFFSET('Consolidated Data'!$A$5,0,0,COUNTA('Consolidated...
  4. C

    Excel Animation

    I've been working with a set of data events that get captured in time by an electronic tracking device. I've managed to manipulate the data to calculate equipment idle time and utilization. Then, I created menus using checkboxes to generate dynamic charts that enable you to choose a particular...
Back
Top