1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. 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...

  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.
Smallman
Last Activity:
May 29, 2017
Joined:
Jul 21, 2013
Messages:
1,217
Likes Received:
328
Trophy Points:
83
Gender:
Male
Birthday:
April 10
Home page:
Location:
Auchenflower, Brisbane, Australia
Occupation:
www.thesmallman.com/

Share This Page

Smallman

Excel Ninja, Male, from Auchenflower, Brisbane, Australia

Smallman was last seen:
May 29, 2017
    1. Mike Zagle
      Mike Zagle
      Hi, just want some help.... I have an excel table with 3 columns. I want to count the unique value of the first column matching cells of the second that are not blank and cells in the third columns that are not blank. The second scenario will be to calculate the count of unique value of the first column matching cells of the second column that are not blank with cells in the third columns that are blank...Thanks
    2. Khalid NGO
      Khalid NGO
      Hello Sir,
      Many returns of the day.
      Happy Birthday.
      1. Smallman likes this.
    3. ALAMZEB
      ALAMZEB
      excel guru..... Thanks for all the helop and above all is your prompt reply
    4. rajkenya1
      rajkenya1
      Hi Small Man. how can i award you with a trophy point?
    5. ismailzkhan
      ismailzkhan
      Hi Smallman,
      with reference to Is it possible to create code for Mouse and Keyboard Movements forum topic.
      Please send this file to me also. My email ID is mail2ismailkhan@gmail.com
    6. sgmpatnaik
      sgmpatnaik
      Thank you for your replay here is my mail id - sgmpatnaik@gmail.com
      1. Smallman
        Smallman
        Hi Patnaik

        I will post it through when I get home from Work.

        Sorry for the delay. If you want to test the code save a picture as Smallman, make a label put it over command button 1 and it should go fine.


        Take care

        Smallman
        Dec 13, 2013
      2. sgmpatnaik
        sgmpatnaik
        No problem, but i tried as per your instruction and i failed to get success may be i am doing some thing wrong, let see from your file and how to do the keyboard movements, i mean when we type some thing then it will record the macro and when we playback then it will run

        no problem take your own time
        Dec 13, 2013
    7. Samytzzz
      Samytzzz
      Hey Smallman... I am thrilled to notice the expertise you have in excel, i have seen you as a saviour to many on various forums. I am trying to record a macro, but the data is too large (error: procedure too large). I will send across the data, also the VBA txt. my email id is samytz@outlook.com. Would be really great if you could do your MAGIC. Thanks :)
      1. Smallman
        Smallman
        Sam - Firstly let me apologise. I am so very sorry I never saw this post of yours. I probably got a notification but I never saw this part of Chandoo before.

        Thanks so much for your kind words. Let me know if you are still having issues. Now I know about people writing in my profile I will check more often.

        Take care

        Smallman
        Dec 13, 2013
  • Loading...
  • Loading...
  • Signature

    About

    Gender:
    Male
    Birthday:
    April 10
    Home page:
    http://www.thesmallman.com/#!dashboards/cfvg
    Location:
    Auchenflower, Brisbane, Australia
    Occupation:
    www.thesmallman.com/