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.
SirJB7
Last Activity:
May 17, 2017
Joined:
Dec 11, 2011
Messages:
8,486
Likes Received:
719
Trophy Points:
113
Gender:
Male
Location:
Buenos Aires, Argentine
Occupation:
Software developer - IT consultant

Share This Page

SirJB7

Excel Rōnin, Male, from Buenos Aires, Argentine

Rōnin (浪人?): Samurai or Ninja with no lord or master, after his death or fall https://en.wikipedia.org/wiki/R%C5%8Dnin Mar 7, 2014

SirJB7 was last seen:
May 17, 2017
    1. Chirag R Raval
    2. Chirag R Raval
      Chirag R Raval
      Dear Sir JB7,
      sorry for disturb ...in your Weekend ..as send you personnel comment on your profile page...I always respect voluntary forums, Peoples
      who Help as they can ..Great help you provide to all.

      Regards,
      Chirag
    3. Chirag R Raval
      1. SirJB7
        SirJB7
        Hi, Chirag R Raval!
        On weekends I try not only to touch a computer but to keep as far away as possible from them. On 3 or 4 days long weekends -as this last one- even more.
        BTW these are voluntary forums, so people who help here are neither morally obliged nor emotionally compelled to behave as if they were omnipresent.
        People have a real life and not only this virtual one.
        Regards!
        May 2, 2017
    4. stevi.d
    5. Poo Prabhu
      Poo Prabhu
      Hey SirJBB7

      I needed some help with macros in excel(for a dynamic range vlookup)
      I hope you can help me on this dear as I need it pretty urgently
      Please email me on prabhupooja0102@gmail.com and I can explain you the problem I am facing with macros
      Many Thanks,
    6. Chirag R Raval
      Chirag R Raval
      DEAR SIR,

      THRE ARE NEED TO PUT "SITE MAP" TO EXPLORE ALL YOUR WEBSITE'S ALL COVERD SUBJECTS TO QUICK JUMP ON PERTICULAR SECTION

      I DEEPLY BELIVE THAT IF YOU PUT WHOLE IDEA OF YOUR SITE IN GRAPHICAL STUCTURE -CLICKABLE & REACHABLE ..LIKE FLOW CHGART....THAT MAKE YOUR SITE UNBELIVABLE SUPPER DUPPER
      WHAT CAN YOU DO FOR YOUR SITE MAKE SUPER??

      HOPE YOU REPLY SOON..

      CHIRAG...
    7. Kavish Sekhri
    8. Mohammed Ashwaq Hussain
    9. Mike Zagle
      Mike Zagle
      Hi Sir, could you help me. I want to know how to count unique value from a column based on the fact that cells of the second column must not be blank and the cells in the third column could or not be blank, therefore 2 conditions for the unique count
    10. deepaktgeorge
      deepaktgeorge
      Dear SirJB7,
      Need help in a similar excel sheet ..
      if you can provide me your email address i could send you a sample as the file is really large
    11. Sarma Akondi V N M
      Sarma Akondi V N M
      hi ronin

      I have seen the objective questions macro you have created. i want your help in creating a retest option wherein it shows only the questions that had answered incorrectly. The retest option should appear at the end of the test until the student finishes the test with all correct answers. will this be possible???


      Thanks in advance
      Sarma

      This is my mail
      sarmacool@gmail.com
    12. Navneet Garg
      Navneet Garg
      Hi Excel Ronin,
      By seeing your post, I know that you know a lot about excel. Therefore I want to ask a question. I want to ask how did you do get the password from the header without any software download, using just programming ?
      forum.chandoo.org/threads/excel-header.7027/
      Can you please explain ? Please !
    13. baskar5353
      baskar5353
      i need this each sheets as separately with in one excel
      can you help me for this
      Thanks & Regards
      Baskar
    14. baskar5353
      baskar5353
      example:
      1. count(excel name) in that sheets name(Name,valid,invalid)
      2.Process(excel name) in that sheets name(Per process,Post process,End process)
      3.Closed(excel name) in that sheets name(Past,Overhead,Maintain)
      in that i need only 3 sheet with new excel as
      In new excel i need as sheet1 as(valid,from excel count) sheet2 as (End process, from excel process) sheet3 as(Overhead from excel closed)
    15. baskar5353
      baskar5353
      Hi,
      I need worksheet from various workbook into one workbook as separate separate sheet
      3 excel are there each excel contain many sheets i need only 3 sheets with new excel
    16. vishal thakral
      vishal thakral
      I am having a workbook where values are as below:
      10
      15
      20
      20
      20
      5

      I want to fetch value from the above cells which is as below:
      Most used number : "20"
      No. of times most used number : "3"
      Least used number : "10" , "5" , "15"

      please email the solution to alliswell@kailashgroup.com
    17. SirJB7
      SirJB7
      1. ThrottleWorks and Luke M like this.
    18. Luke M
      Luke M
      Congrats on collecting all the trophies. Apparently, you've managed to fool the server into thinking you're the "most liked" member.
      =P
      1. View previous comments...
      2. SirJB7
        SirJB7
        full... foul... fool... just 2 steps away from the thruth... :P:P:P
        Mar 4, 2014
      3. Luke M
        Luke M
        *type type*
        "full"?? I don't see the word full. Not sure what you're talking about. ;)
        Mar 5, 2014
      4. SirJB7
        SirJB7
        Got a screenshot... Let me blackmail you... 10 grands?... one time offer... expires in 10... 9... 8...
        Mar 5, 2014
    19. SirJB7
      SirJB7
      Status? ... quo, for the time being.
    20. SirJB7
      SirJB7
      Hi, Yizthackm! You're welcome. Thank you for your kind words. Regards!
    21. Yitzhackm
      Yitzhackm
      Sir JB7, I just wanted to say thank you for all you do for people like me. sharing your knowledge is greatly appreciated. SIRJB7, es usted grandioso.. Gracias :)
      1. SirJB7 likes this.
    22. SirJB7
      SirJB7
      Status? ... quo, for the time being.
    23. SirJB7
      SirJB7
      ... quo, for the time being.
  • Loading...
  • Loading...
  • About

    Gender:
    Male
    Location:
    Buenos Aires, Argentine
    Occupation:
    Software developer - IT consultant
    From Groucho:
    I don't want to belong to any club that will accept people like me as a member.
    Those are my principles, and if you don't like them... well, I have others.
    There are many things in life more important than money... but they cost so much!
    A black cat crossing your path signifies that the animal is going somewhere.

    From Albert Einstein:
    We are all very ignorant, what happens is that not all ignore the same things.

    From cryptography:
    If 9W is the answer, what is the question?
    Do you spell your name with a "V" Herr. Wagner?

    From the very far East:
    If you sit by the river long enough, you will see the body of your enemy float by.

    From who knows?:
    If you fall, I'll be there. (Floor)

    From Jânio Quadros (São Paulo's Major and Brazilian President):
    Eu bebo porque é líquido, se fosse sólido eu comia
    Bebo-o porque é líquido, se fosse sólido comê-lo-ia
    Desinfeto porque nádegas indevidas se sentaram nela.