• Microsoft Office
  • Microsoft Windows
  • Other Software
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us
Excel

Tips for quickly comparing data tables in Excel

0 Comments

Tips for quickly comparing data tables in Excel: During the process of working with Excel, comparing and matching data is a common task, especially for accountants. In this article, Buffcom.net will share with you how to compare data tables in Excel.

For example, let’s say we have two tables of prices for products from 1 to 9 in the years 2018 and 2019 as shown in the figure below. The requirement is to compare which product prices in 2019 have changed compared to 2018, and which product prices in 2019 remain the same as in 2018. To compare, please follow the steps below.

Step 1

To compare prices between two years, first select and highlight all the data that needs to be compared in the two tables. Drag the mouse to select the 2018 data table. Then press and hold Ctrl and drag the mouse to select the 2019 data table.

Tips for quickly comparing data tables in Excel

Tips for quickly comparing data tables in Excel

Step 2

Next, select the Home tab on the toolbar. Then select Conditional Formatting under the Styles section.

Tips for quickly comparing data tables in Excel

Tips for quickly comparing data tables in Excel

Step 3

The scroll bar appears, select Highlight Cells Rules. Next, select Duplicate Values.

Tips for quickly comparing data tables in Excel

Tips for quickly comparing data tables in Excel

Step 4

At this point, the Duplicate Values dialog box appears. Under the Format cells that contain section, select Duplicate to highlight cells with duplicate data. Under the Values with section, you can click to select a color, highlight border. Here are the colors for you to choose from:

  • Light Red Fill with Dark Red Text: Highlight cells with light red background and dark red text
  • Yellow Fill with Dark Yellow Text: Highlight cells with yellow background and dark yellow text
  • Green Fill with Dark Green Text: Highlight cells with green background and dark green text
  • Light Red Fill: Highlight cells with light red background
  • Red Text: Highlight cells with red text
  • Red Border: Highlight cells with red border
  • Custom Format: Select custom colors as desired

After you have made your selection, click OK to complete. You can see that the products whose prices in 2019 have not changed compared to 2018 have been highlighted, namely SP 01, 03, 04, 05, 07, 08, 09.

Tips for quickly comparing data tables in Excel

Tips for quickly comparing data tables in Excel

Step 5

If you want to highlight the data that does not match, simply select Unique under the Format cells that contain section. Then click OK to complete. You can see that the products whose prices in 2019 have changed compared to 2018 have been highlighted, namely SP 02 and SP 06.

Tips for quickly comparing data tables in Excel

Tips for quickly comparing data tables in Excel

So, this article has guided you on how to compare data tables in Excel. Hopefully, this article will be useful to you in your work. Wish you success!

4
56 Views
Keyboard shortcuts commonly used in ExcelPrevKeyboard shortcuts commonly used in ExcelApril 11, 2023
How to use Goal Seek tool to find breakeven point in ExcelApril 11, 2023How to use Goal Seek tool to find breakeven point in ExcelNext

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Recent Posts
  • Retrieve Data Based on Data Validation
    September 7, 2023
    Excel
  • How to Convert Multiple Rows to Columns and Rows in Excel?
    September 6, 2023
    Excel
  • VLOOKUP for Automatic Discount in Data Validation
    September 6, 2023
    Excel
  • How to Convert Text Dates to Dates in Excel?
    September 5, 2023
    Excel
Categories
  • Blog 80
  • Excel 754
  • Powerpoint 36
  • Software tricks/tips 128
  • Uncategorized 8
  • Word 109
Tags
the ISERROR
Top rated products
  • Trend Micro Internet Security 3 Devices 1 Year Key GLOBAL Trend Micro Internet Security 3 Devices 1 Year Key GLOBAL
    Rated 5.00 out of 5
    $17.00
  • Windows 11 Pro Key Global
    Rated 5.00 out of 5
    $11.00
  • AVG Internet Security 2021 10 Devices 2 Years Global AVG Internet Security 2021 10 Devices 2 Years Global
    Rated 5.00 out of 5
    $42.20
  • Trend Micro Maximum Security 3 Devices 1 Year key Global Trend Micro Maximum Security 3 Devices 1 Year key Global
    Rated 5.00 out of 5
    $15.00
  • Windows 11 Home Key Global 2021
    Rated 5.00 out of 5
    $15.00
Products
  • Buy Office 2021 Professional Plus Key Global For 5 PC
    Rated 5.00 out of 5
    $45.00
  • Buy Office 2021 Professional Plus Key Global Bind To Your Microsoft Account
    Rated 4.83 out of 5
    $49.00
  • Windows Server 2022 Datacenter Key Global
    Rated 5.00 out of 5
    $15.00
  • Windows Server 2022 Standard Key Global
    Rated 4.47 out of 5
    $15.00
  • Windows Server 2022 Remote Desktop Services Device Connections (50) Cal Key Global
    Rated 5.00 out of 5
    $45.00

Buffcom.net always brings the best digital products and services to you. Specializing in Office Software and online marketing services

BIG SALE 50% IN MAY

Microsoft Office
Microsoft Windows
Anti-Virus
Contact Us

Visit Us:

125 Division St, New York, NY 10002, USA

Mail Us:

buffcom.net@gmail.com

TERMS & CONDITIONS | PAYMENT GUIDE  | SHIPPING POLICY  | REFUND POLICY

Copyright © 2019 buffcom.net  All Rights Reserved.