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

    Filtered Worksheet

    Good afternoon all, can someone please help? I have a spreadsheet, I use my filter to filter my new worksheet and now I want to use SUM to add up a column, but it does not work, what Formula should I be using?
  2. A

    Yearly Training Schedule

    Can someone please help, I am trying to put together a training plan for 170 peoples for next year. Some of the employees work a shift pattern some do not, where do I start? Does anyone have an example that I can use to kick start my brain, Thank You
  3. A

    Rating a group

    Dear Sirs, can you please help? I have 7 groups of people with varying numbers of people in the groups. For example one group as 30 people another group 10 people. They are all arranged in their groups by an average number due to scores they take on a test. Now what I want to do is arrange the...
  4. A

    Viewing a Chart from Format Control?

    I am a novice at Excel so can someone help me please, I have a Dashboard with a Format control box on my front sheet with the months of the year in, when I select a month of the year I want to bring up a chart, can some one please help, thank you.
  5. A

    Conditional Formatting Question.

    Got it, many thanks NARAYANK991 you have made an old man happy!
  6. A

    Conditional Formatting Question.

    In the post to you Hui! thankyou
  7. A

    Conditional Formatting Question.

    Gentleman thankyou for your help, I have done what NARAYANK991 suggested, this is what I did before! (Its hard to explain) but why if the number in I10 is the same as the number in I9 I don't get an Orange Arrow? Green and red are OK if there is a difference one way or the other but why no...
  8. A

    Conditional Formatting Question.

    Can you please advise! I am using Excel 2007, I am trying to use conditionaly formatting Icons. Basically when I get a higher figure below a figure above I get a Green Arrow pointing upwards, this is working. When the figure below is less than the figure above I get a Red arrow pointing down, ok...
  9. A

    Count Down

    Thankyou very much, always looks easier afterwards, much appreciated.
  10. A

    Count Down

    Hello All, I am a new member, love excel but very "green" can anybody give me a formula which shows "Days" count down. I am building a Gnatt Chart which I am tracking my progress on completing certain task and I want to show "days Count Down" to when I am expected to finish my project.
Back
Top