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

    How can I average the last 30 entries by date?

    Hi Hui, thanks for the post. Really appreciate it. But... Your formulae brings back a result but what it is doing is taking the top 30 entries by date (good so far) then filtering out the non "New"s and averaging what is left. Any ideas?
  2. G

    How can I average the last 30 entries by date?

    Hi, thanks for both of your replies. I would like to do it with a formulae but what I can't get my head around is how to get the last 30 entries by date as they don't come in date order (unfortunately). Any ideas?
  3. G

    Hello .. Introduce yourself

    Hi everyone, my name is Mags and I'm new a newbie having found your site when looking for help with my excel questions. It is by far my favourite and I probably visit at least once daily. I am a project manager for a telecom company and am currently trying to improve our MI reporting, hence my...
  4. G

    How can I average the last 30 entries by date?

    Hi everyone. This is my first time posting and I'm a bit of a newbie to excel but am learning so much from your excellent site. I have a list as below: A B C D E F G H Ref Type Project Manager Customer Name Assigned date Go...
Back
Top