• 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

    Counting errors in Rich Data types

    Lol - funny how writing a problem down makes you think about it in a different way. If I use a combination of a DOT Formula and a regular error count I can get the answer :) Apologies if I have wasted your time !
  2. J

    Counting errors in Rich Data types

    Hi - we have a large Excel workbook that we are using to log requests. To help with data integrity we have a control dashboard (separate tab) that identifies any columns with missing or wrong values in the main data set. One of the fields in the data set is Country and we are using the Rich...
  3. J

    Calculating the worst entry in a group of entries

    Wow - that is clever. If I get the logic here you are using the Choose function (not used this before) to select one of the four labels, with the array minimum calc to define the index for Choose Think I will run with this and see how we get on. Big thanks both Peter and p45cal - really...
  4. J

    Calculating the worst entry in a group of entries

    Peter - many thanks for this - really appreciate it. Its exactly what I was after - just need to get my head round how and why it works and apply it to my real data. Again, many thanks :) Joe
  5. J

    Calculating the worst entry in a group of entries

    Sorry - file now attached (I was unable to upload from my work pc due to security settings) I have included the request in the top of the sheet, this time making ref to the cols. I'm keen to create a formula to create the values that I have manually entered in Col D Big thanks for any help Joe
  6. J

    Calculating the worst entry in a group of entries

    Hi - I'm part of a team that undertake a control assessment every month. We have a large number of controls which in turn can have any number of lower level sub-controls. We rate each of the sub-controls either Complete, Green, Amber or Red. I have a simple report that runs across the...
  7. J

    9 box grid - talent chart

    Thank you so much for the fast response. My apologies for not getting back sooner - unfortunately the day after I posted I came down with a nasty bug and have been off work ever since. First day back today. Allow me to catch up on a mountain of work and I will take a good long look at the...
  8. J

    9 box grid - talent chart

    Hi - I have been an avid follower for a while and am always impressed by the simplicity and elegance of the solutions here. I am currently struggling with an HR challenge - how to present the findings of a talent bench review for up to 150 people. Employees are rated on Performance, Potential...
Back
Top