Get Digital Help
  • Home
  • Templates
  • Products
  • Categories
    • Advanced Filter
    • Automate
    • Combine/Merge
    • Compare
    • Conditional Formatting
    • Count Values
    • Dates
    • Drop Down Lists
    • Duplicate Values
    • Finance
    • Misc
    • Pivot Table
    • Random
    • Records
    • Search/Lookup
    • Sort Values
    • Templates
    • Unique Distinct Values
    • Unique Values
    • Unique Values
    • User Defined Functions
    • VBA
    • VLookup
    • Unique/Duplicates
    • Sort values
    • Count values
    • Search/Lookup
    • Microsoft Excel
  • Archive
  • Contact
    • Contact me
  • About Me
    • About me
    • Blogs I read
      Popular categories

       Automate

       Charts

       Compare

       Conditional formatting

       Count values

       Dates

       Drop down lists

       Misc

       Pivot tables

       Search/Lookup

       Sort values

       Tables

       Templates

       UDF

       VBA

       Vlookup

      • Advertise Here

      Dashboard reporting with excel This e-book teaches you how to create your own Excel dashboard reports, starting from scratch. Learn how to create mini-charts, how to use Excel's Camera tool, how to set up Excel databases, and a lot more.


      Excel Worksheet-Formula Add-Ins allows worksheet formulas to change chart settings. For the first time ever, your formulas can create traffic-light charts, highlight chart elements, assign number formats, and much more.


    Get Digital Help > Excel > Advanced filter

    Archive for the ‘Advanced filter’ Category

    Create a unique distinct list of a long list without sacrificing performance using vba in excel
    Filter unique distinct values using “contain” condition of a column in excel
    Advanced custom date filter in Excel 2007
    How to extract a unique distinct list from a column in excel
    • Subscribe subscribe  

    • Blog updates by email:

    • Welcome! I am Oscar and here to help you! Feel free to comment and ask excel questions.
      Don´t forget to add my RSS feed and subscribe to new blog articles by email.

    • Recent Comments

      • Oscar on Populate a list box with visible unique values from an excel table (vba)
      • Oscar on Sum values in a range where adjacent cell value equals a criterion in excel
      • aMareis on Highlight unique distinct values in two ranges combined using conditional formatting in excel
      • G. Cooley on Highlight events in a calendar
      • Alaa Abdullnabi on Merge two columns with possible blank cells in excel (formula)
      • Oscar on Merge two columns with possible blank cells in excel (formula)
      • Oscar on Calculate your stock portfolio performance in excel
      • Oscar on Formula for matching a date within a date range in excel
      • Ag on Excel vba: Save invoice data
      • Oscar on Create a unique distinct list of a long list without sacrificing performance using vba in excel

    • Recent Posts

      • Count students
      • Use a map in an excel chart
      • SEARCH and FIND functions
      • Yet another excel calendar
      • MMULT function – Matrix multiplication
      • SMALL function and LARGE function
      • Copy/Rename a file (excel vba)
      • Assign each person with randomly unique objects as a daily activity
      • ROW function explained
      • Highlight duplicates in a filtered excel defined table
    Oscar Cronquist