• Welcome to Excelguru

    Welcome to Excelguru!

    A message from President and Chief Training Officer, Ken Puls, FCPA, FCMA, Microsoft MVP

    My favourite definition of the word Guru is "Remover of darkness". A guide. A teacher. It is in this spirit that the Excelguru website was created: to help remove the mysteries of Excel and Power BI, help you find solutions, help you to be more proficient or accomplish certain tasks.My passion lies in exploring tools to turn data into information, and teaching others how to benefit from them.

    The team at Excelguru is dedicated to helping you get the most from your data by leveraging tools you already own through On-site and Online Training,Consulting and Mentoring Services, Technology Blog, and a freeOnline Help Forum and Knowledge Base. We specialize in:

    - Excel

    - VBA

    - Charting and Dashboarding

    - Power Pivot

    - PivotTables

    - Power Query

    - Power BI

    EXCELGURU NEWSLETTER

    Keep up-to-date with Excelguru by signing up to receive our monthly(ish) Excelguru email newsletter. It features the latest updates for Excel and Power BI, upcoming training sessions, new products and other information.

    As a "thank you" for subscribing, we are excited to share our FREE eBook series, 'DIY BI' Tips, Tricks & Techniques. Don't miss out - sign up today!

    Subscribe to our mailing list

    * indicates required
  • MVP Logo
  • Recent Forum Posts

    Bob Phillips

    VBA Programming help

    Code:
    Public Sub KeepHighest()
    Dim lastrow As Long
    Dim i As Long
        
        Application.ScreenUpdating = False
        With ActiveSheet
    ...

    Bob Phillips Today, 10:56 AM Go to last post
    Shoeboxken

    VBA Programming help

    I would like to use a VBA coding to create a list of information pulled from a data set.

    Data would include the following info as examples:...

    Shoeboxken Today, 05:36 AM Go to last post
    facams

    delete duplicate entries

    Thank you sir will try it...

    facams Yesterday, 09:00 PM Go to last post
    Bob Phillips

    delete duplicate entries

    Code:
    Public Sub DeleteDuplicates()
    Dim lastrow As Long
    Dim i As Long
        Application.ScreenUpdating = False
        
        With ActiveSheet
    ...

    Bob Phillips Yesterday, 08:25 PM Go to last post
    facams

    delete duplicate entries

    HI, new here. I need help in deleting duplicate cells that have same name or account # then based on an action that states "report" even if...

    facams Yesterday, 07:57 PM Go to last post