• Awards

    Microsoft MVP (Excel)
    One of the biggest honours I've received is to be awarded the Microsoft MVP award for Excel

    The following quote best explains the MVP award:
    Quote Originally Posted by Rich Kaplan and Sean O'Driscoll of Microsoft
    The Microsoft Most Valuable Professional (MVP) Program recognizes and thanks outstanding members of technical communities for their community participation and willingness to help others. The program celebrates the most active community members from around the world who provide invaluable online and offline expertise that enriches the community experience and makes a difference in technical communities featuring Microsoft products.
    MVPs are credible, technology experts from around the world who inspire others to learn and grow through active technical community participation. While MVPs come from many backgrounds and a wide range of technical communities, they share a passion for technology and a demonstrated willingness to help others. MVPs do this through the books and articles they author; the Web sites they manage; the blogs they maintain; the user groups they participate in; the chats they host or contribute to; the events and training sessions where they present, as well as through the questions they answer in technical newsgroups or message boards.

    Microsoft MVPs are simply an amazing group of individuals. We are excited to recognize and award MVPs as our way of saying "thank you" for their demonstrated commitment to helping others in technical communities around the globe.
    The Microsoft MVP distinction is awarded annually, and must be re-earned every year. I was first awarded on October 1st, 2006, and an proud to say that I have be re-awarded every year since then.

    My Microsoft MVP profile can be found here.

    This award also spawned a Press Release by my accounting body (CMABC), which in turn led to a mention in the Vancouver Sun's Kudos section on June 25, 2007.

    Cell Master
    I have also been flattered to receive the 30th Cell Master award at Colo's Excel site. For those not in the know, Colo is a very gifted Excel MVP from Japan, and this was a very select list of extremely talented indivduals. (Honestly, I'm not quite sure I deserved to be on there!) Unfortunatley Colo's site is no longer running, but the interview that Colo and I did can still be accessed via the Wayback Machine.

     

    I'm afraid that you must be logged in to comment or leave a testimonial. I wish it could be otherwise, but I'm trying to keep my site spam free for everyone's benefit. If you don't yet have an account it's completely free to sign up, and a very quick process. Simply click here to Register. Not only can you post a comment here, but it gives you full access to posts questions in our forum as well!

     

    If you already have an account, and just haven't logged in yet, what are you waiting for? Login Now!

  • MVP Logo
  • Recent Forum Posts

    Logit

    unduplicated list

    If you also include the "Check Run Date" column in the table as well, that will provide a means of selecting which month.

    Code:
    
    
    ...

    Logit Today, 04:35 PM Go to last post
    BuddyGSD

    unduplicated list

    Is there a way for excel to gather the names of the families from the month of April and May to appear on the Undup Clients tab then?...

    BuddyGSD Today, 04:08 PM Go to last post
    NoS

    Sum cells in each generated row

    Along with writing the form data to the sheet you could write a formula into the O column

    Code:
    Cells(whateverrow, 15).FormulaR1C1="=SUM(RC[-9]:RC[-1])"
    ...

    NoS Today, 02:27 PM Go to last post
    p45cal

    If overide formulae

    Array-enter (Ctrl+Shift+Enter, not just Enter) and copy down:
    =INDEX({"Fail";"Risk";"Pass"},MIN(MATCH(T2:U2,{"Fail","Risk","Pass"},0)))...

    p45cal Today, 12:14 PM Go to last post
    jonespandrew

    If overide formulae

    Sorry I have read you last response wrong Write

    Fail Risk would be a fail
    Risk pass would be a Risk
    Risk Fail would be a fail...

    jonespandrew Today, 11:14 AM Go to last post