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

    IF calc auto filter query

    Brilliant, thank you again Luke Clare
  2. C

    IF calc auto filter query

    Yes, it is the number of visible "yes"s.
  3. C

    IF calc auto filter query

    Hi Please can someone help with a solution to filtering a column and the IF calculation. I have used the IF calculation on the word yes in a column. I now need to put a filter on the column and want to be able to count the yes's in the filtered information, but the IF calculation only shows...
  4. C

    How to calculate a percentage on filtered information

    Thanks for the help Luke.
  5. C

    How to calculate a percentage on filtered information

    Thanks for your help, can you tell me is 103 the code for COUNTA in the spreadsheet?
  6. C

    How to calculate a percentage on filtered information

    Hi Please can someone tell me if there is a way to calculate a percentage value of a column of filtered data? I have been able to calculate a percentage value on yes/no ratio on the full data, but need to be able to filter and calculate the percentage of yes/no on the remaining data showing...
  7. C

    Vlookup with Drop Down options

    Thank you for your help with the examples, I will give them a try and fingers crossed I will be able to get these to work. Regards
  8. C

    Vlookup with Drop Down options

    Hi I am trying to create an information table where a user will be able to pick a name from a drop down list in the first column. I then want options available under the name chosen, to become available in the second column and this is to also be shown in a drop down (as there may be many...
Back
Top