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

    MATCH Struggling with 00:00:00 format values?

    Hey chandooistas, I am no guru, but i'm decent enough with excel and this has me stumped. I have a list of times starting at 00:00:00 and increase in ten second increments. In the next column is a value. In another table i want to match against various times and return the corresponding...
  2. J

    Formula Return bottom 3 values from an array/table based on a criteria?

    Thanks ashish, with the helper column in column D in place i've used your formula on the top example and it looks like it works! INDEX(A:A,SMALL(IF($D$6:$D17=F8,ROW($D$6:$D17),""),COUNTIF($F$6:F8,F8)))
  3. J

    Formula Return bottom 3 values from an array/table based on a criteria?

    OK, i've figured out how to take the Region into account. Simply adding a helper column that populates depending on whether the region has been selected or not. Then you can do the SMALL calculation on that column, still trying to figure out how to return the names of the engineers for the...
  4. J

    Formula Return bottom 3 values from an array/table based on a criteria?

    Thanks Ashish - that formula works if the bottom 3 values are the same, but if you change the data so the bottom 3 values are different you get a #num error. Also, i still can't figure out how to let the user reference the region! very frustrating because it sounds easier than it is turning...
  5. J

    Formula Return bottom 3 values from an array/table based on a criteria?

    Hi! Got a bit of a head scratcher here. I have list of engineers, by region and a "score" for each. I want a formula that will return the three worst performing engineers for whatever region the user selects. I have tried various formula using small, index & match but am completely stuck...
Back
Top