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

    Need some VBA Help

    Hi all, I created a test workbook so I can work on a way to capture and record user activity in my workbooks, and record any changes made into a log.txt file, and then email the log file to me. We've recently had problems with workbooks being modified without proper authorization so I...
  2. N

    Idea: Conditional Formating activating alert box.

    Hi everyone, So I had an idea, and for argument's sake I'll use product pricing to elaborate on it. -Say you got 6 Columns (A -> Product Name, B-> Date/Time, C-> Price, D-> 1st Formula, E-> 2nd Formula, F -> Check Formula) - Columns A,B,C are just standard data, no...
  3. N

    MODE() Array formula.

    Hi, I have the following array formula: {=IF($BK30=0,0,IF(ISERROR(MODE(IF('LASTPRICE!$C$1:$C$50000=$BF30,'LASTPRICE'!$G$1:$G$50000))),AVERAGE(IF('LASTPRICE'!$C$1:$C$50000=$BF30,'LASTPRICE'!$G$1:$G$50000)),MODE(IF('LASTPRICE'!$C$1:$C$50000=$BF30,'LASTPRICE'!$G$1:$G$50000))))} What it does...
Back
Top