• 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

    Do not display IF ZERO

    Found this: http://office.microsoft.com/en-us/excel/hp051998791033.aspx#Use%20a%20number%20format%20to%20hide%20zero%20values%20in%20selected%20cells
  2. N

    Do not display IF ZERO

    Occassionally, I need to use the formula =if(A1-B1=0, "", A1-B1) in C1; A1,B1,C1 being any cell or A1-B1 representing any formula and C1 representing target cell. It is tiresome to edit each required cell with the if statement. Can someone write a VBA for this. This function, let's call it...
  3. N

    Display record (from a set of records using drop down)

    Hi, We use XL to capture client feedback. All responses are captured in an XL worksheet row-by-row with column headings being the question nos. Each record is unique to each survey. My problem is: Based on a user selectable record via a Combo Box (pertaining to a particular survey), display...
View older results
Back
Top