• 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

    Quality form with Transpose

    Hi, I am trying to make a Quality form in Excel, the questions will be one below the other with a drop down to choose from ( Yes, No, N/A) or Points (10, 15,20,30 etc). I want a macro that helps me transpose all the results of one evaluation to a new sheet in horizontal format and add the...
  2. S

    Need help with loop entry

    Hi All, I am trying to create a radom sampler for selecting random cases for audit, attached si the macro created. Within this macro i am unable to add the loop entry to ensure that the random formula is applied to the last entry in the 1st column. Kindly assist
  3. S

    Count if with count A array [SOLVED]

    Hi All, I wanted to check for a little modification in using Count(if with a count A condition. Attaching a dropbox link for sample file... https://www.dropbox.com/s/jd4nclj6owt4s2p/Status%20Report.xlsx?m I am trying to get a count of "cells with text" in Defect Calculation sheet based on...
  4. S

    countif based on multiple conditions

    Hi, i am trying to do a count if based on 3 conditions... Currently am using =COUNT(IF((Sheet2!$E$3:$E$12=$B3)*(Sheet2!$C$1:$C$12=Sheet2!$E$2),Sheet1!$F$2:$F$12))as an array.. but it dosent return the count of data from F2:F12. I have a sample seet that i can send across, dont know how to...
Back
Top