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

      Most Popular Blog Posts

      How to extract a unique distinct list from a column

      How to return multiple values using vlookup

      Create a date range using excel formula

      Count unique distinct values in a column

      Sorting text cells using array formula

      How to create a dynamic chart

      Match two criteria and return multiple rows

      Merge two columns into one list

      Lookup with multiple criteria and display multiple search results using excel formula

      Find latest date in a list

    • 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.
    • Random Data Generator 250x250 ad 3
    • 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.


    You are here: Home >> Excel >> Records

    Archive for the ‘Records’ Category

    Unique distinct records sorted by frequency
    Compare two tables in excel: Remove common rows
    How to sort a table in a custom order in excel
    Quickly compare two tables in excel 2007
    Excel 2007 pivot table: Count unique distinct records (rows)
    Sum unique distinct invoices in excel 2007
    Filter unique distinct records with a condition in excel 2007
    Excel udf: Filter unique distinct records (case sensitive)
    Quickly highlight records containing text strings in excel (AND Logic)
    Quickly highlight records in a list in excel (AND logic)
    Quickly highlight records in a list using multiple criteria in excel
    Find duplicate records in excel 2007
    Count unique distinct records in excel 2007
    Compare two lists of data: Filter records existing in only one list in excel
    Compare two lists of data: Highlight records existing in only one list in excel
    Compare two lists of data: Highlight common records in excel
    Compare two lists of data: Filter common row records in excel
    Filter and highlight duplicate column records in excel 2007
    Filter duplicate rows in excel 2007
    Highlight duplicate rows in excel 2007
    Match two criteria and return multiple rows in excel
    Vlookup of three columns to pull a single record
    Filter unique distinct row records in excel 2007
    « Previous Page — « previous entries
    next entries » — Next Page »
    • Related blog posts

      • Count unique distinct records in excel 2007
      • Count unique distinct values that meet multiple criteria in excel
      • Count unique distinct records with a date and column criteria in excel 2007
      • Filter unique distinct records with a condition in excel 2007
      • Filter unique distinct row records in excel 2007
      Add RSS 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

      • Tom on How to return multiple values using vlookup in excel
      • Tom on Use a drop down list to extract and concatenate unique distinct values
      • Jonah on Excel udf: Lookup and return multiple values concatenated into one cell
      • hrvoje on Extract a unique distinct list from two columns using excel 2007 array formula
      • khuram khalil on How to return multiple values using vlookup in excel
      • Nick on How to extract a unique distinct list from a column in excel
      • Ryan on Sorting text cells using array formula in excel
      • Paul on How to return multiple values using vlookup in excel
      • Oscar on How to return multiple values using vlookup in excel
      • Oscar on Match two criteria and return multiple rows in excel
    • Recent Posts

      • Create comments in cells whose value is larger than the column width
      • Lookup multiple values in different columns and return a single value
      • Learn how to return values depending on udf deployment (vba)
      • Select a cell in a table and the chart updates automatically (vba)
      • Excel template: Getting Things Done (vba)
      • Disable autofit column widths for all pivot tables in a sheet
      • Vba macro: Normalize data
      • Date ranges: Weeks within a month
      • Add values to different sheets (vba)
      • Add values to a table (vba)