Archive for Records
Compare two tables: Remove common rows
Table of Contents Compare two tables: Remove common rows Compare two tables using a condition Let me demonstrate how to extract […]
How to sort a table in a custom order in excel [No formula]
Your boss wants you to sort the company´s products by a new criterion, quality. You receive a list from your […]
This blog post demonstrates how to quickly compare two tables in Excel. Table1 Table2 Create a fourth column and use […]
This blog post shows you how to create a conditional formatting formula and highlight matching records. You can easily change […]
Highlight records – multiple criteria [OR logic]
This blog post shows you how to highlight rows with multiple criteria using OR logic. The criteria is found in […]
Compare two lists of data: Filter records occurring in only one list
In this example we are going to use two lists with identical columns in excel 2007. It is easy to […]
Compare two lists of data: Highlight records occurring in only one list
Overview There are two lists in this example: Sheet: List 1 Sheet: List 2 Create named ranges Select A2:A13 on […]
Compare two lists of data: Highlight common records
Overview In this blog post you will learn how to: Create a countifs function Create a conditional formatting formula and […]
Compare two tables: Filter common records
I will in this blog post describe how to extract common records from two data sets in Excel. I have […]
This article describes how to highlight duplicate records and filter duplicate records. There is one record in each column, cell […]
