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

Recent content by gumbles

  1. G

    Using COUNTIFS with the LEFT function

    Cheers Hui.
  2. G

    Using COUNTIFS with the LEFT function

    Hey Murugesh, Yea I had this idea too, but was seeing if there might be a more elegant solution but I guess not ha. Thankyou for you input though, it has confirmed my initial idea.
  3. G

    Using COUNTIFS with the LEFT function

    Thanks Hui that works Great. Do you have any advice for including 2 other table ranges in this without alot of repeating?
  4. G

    Using COUNTIFS with the LEFT function

    Hello, I am trying to count the number of entries in 3 tables that have "M5" as the first two digits by combining a countifs with the left function but I cannot make it work. My attemps (which only use one table as they are tests) to far are as follows...
  5. G

    Hiding and Unhiding Rows with Filter Applied

    Congratulations! Yes that makes perfect sense and thank you so much for your help!
  6. G

    Hiding and Unhiding Rows with Filter Applied

    Wooo! That seems to have done the trick. Thank you. Sorry to be a pain, but could you explain why the "On Error" code is bad practice because Ive heard that before from other coders, but never understood why... Regards, Gumbles.
  7. G

    Hiding and Unhiding Rows with Filter Applied

    Oh and I did duplicate your tests and they were the same.
  8. G

    Hiding and Unhiding Rows with Filter Applied

    Hi Luke, Cheers for your time. Ah yes, thats the macro that prints the charts for Display. I got that code from another forum and it used PDF Creator to run and is installed on all the Machines that use it and shouldnt interfere with the first section of code. I should probably explain how...
  9. G

    Hiding and Unhiding Rows with Filter Applied

    No Apologies necessary Luke, I just reposted to make sure I didnt forget where the thread was lol.
  10. G

    Problem with sorting blank cells got as results from formulas

    Hi Davecrt, This isnt the most elegant solution, but you could make the output: If(ISBLANK(A1),-9999,A1) Then Conditional format -9999to be invisible. OR you could put an Auto filter on that column, unselect blanks then filter largest to smallest. Not the neatest solutions though...
  11. G

    Hiding and Unhiding Rows with Filter Applied

    Sorry to Re post but ive no idea how to solve this definition issue.
  12. G

    Problem with sorting blank cells got as results from formulas

    Hello Davecrt, Have you tried the "N" function? It converts values to numbers and if it doenst match a value it turns it to Zero (which would ut it to the bottom) Try nesting it in your formula as an output as see if it helps. Gumbles
  13. G

    Hiding and Unhiding Rows with Filter Applied

    Any luck? Ive been experimenting with different types of variables but still getting stuck on defining the criteria.
  14. G

    Hiding and Unhiding Rows with Filter Applied

    Here's a link to the file, so you can see. I've checked it for sensitive information and your all clear. https://www.dropbox.com/s/9c9si34y9e987bc/ESDID_SQCDP_Test.xlsm
  15. G

    Hiding and Unhiding Rows with Filter Applied

    Yea, and its still having an error with both Criteria as a definition error.
See more
Back
Top