• Sales Affiliate Program

    Excelguru Affiliate Program

    If you have a website or blog, or distribute newsletters by email, you can earn up to 30% in commissions by selling Excelguru products!

    All commissions are tracked by e-Junkie, the same vendor I use to sell all my products, and commissions are paid out on the 15th of the month following sale via PayPal. So what are you waiting for? Join the Affiliate Program now!

    The Magic of PivotTables Video Course

    Below is an animated banner (728 x 90 pixels) you can use to help you sell the course and earn a commission. If you would prefer to use your own images with these links, or insert links inline with text in your web pages, feel free. We're fine with whatever you feel works best with your site.

    If you'd like to see banners of different shapes, sizes or styles, please let us know. We'll do our best to help!


    HTML CODE:
    <a href="https://www.e-junkie.com/ecom/gb.php?ii=1088604&cl=AFFILIATE&c=ib&aff=AFFILIATE" target="ejejcsingle" title="XLG Magic of PivotTables"><img src="//www.excelguru.ca/images/xlgmopt728x90.gif" border="0"/></a>

    Replace AFFILIATE in the code above with your e-Junkie Affiliate ID and insert the code into the html code of your webpage, blog or email newsletter.



    ExcelTV Affiliate Program

    Excelguru has produced two courses in conjunction with ExcelTV:
    • Error Checking for Excel BI Solutions
    • Building BI with PivotTables

    These courses have a separate affiliate program that is managed entirely through ExcelTV. Affiliates receive a 50% commission on any sales, ExcelTV provides a variety of banners and ads for affiliates to use, as well as sample text that can be used in emails. Visit the ExcelTV Affiliate page for details and registration.

     

    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

    p45cal

    Complex counting help

    The table in the latest file needs refreshing - I should have done that myself - sorry....

    p45cal Yesterday, 05:45 PM Go to last post
    Mr_E_Man

    Complex counting help

    Hi p45cal - I think there is still some error in the logic but your suggestion of using Power Query has been invaluable. I have been researching that...

    Mr_E_Man Yesterday, 05:35 PM Go to last post
    p45cal

    Complex counting help

    Attached adjusted accordingly....

    p45cal 2020-08-04, 11:31 PM Go to last post
    Mr_E_Man

    Complex counting help

    Hi p45cal - the specific "DT" function is the only one that does not get counted for the keypad on the 2nd or 3rd reference, it is different...

    Mr_E_Man 2020-08-04, 05:55 PM Go to last post
    p45cal

    Complex counting help

    The attached contains a table at cell I6, which agrees with your totals except for the keypad count of the first site (1185) where I have counted the...

    p45cal 2020-08-04, 03:05 PM Go to last post