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

    Max function in Excel 2010

    Well I wasn't - but you've cracked it thank you. Sparkles
  2. S

    Max function in Excel 2010

    Thanks However Autocalculate is on and F9 'appears' to remove the formulae!
  3. S

    Max function in Excel 2010

    Also tried:- =MAX(--(Purchase!$B$2:$B$70=A2),--Purchase!$F$2:$F$70) with the same problem - incorrect in the cell, yet correct in the function argument window! Help Rgs
  4. S

    Max function in Excel 2010

    I'm working on improving my stock keeping system and have been trying to use the Max function with varing results. The formulae below is designed below to find the maximum purchase paid for a raw material. =MAX((Purchase!$B$2:$B$70=A2)*(Purchase!$F$2:$F$70)) Purchase! Column B is the...
Back
Top