• Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • 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
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • 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
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • 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
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • 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!

Rate this post
21
254 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

You must be logged in to post a comment.

Buy Windows 11 Professional MS Products CD Key
Buy Office 2021 Professional Plus Key Global For 5 PC
Top rated products
  • Kaspersky Small Office Security 15 PCs + 15 Mobiles + 2 Servers 1 Year Kaspersky Small Office Security 15 PCs + 15 Mobiles + 2 Servers 1 Year
    Rated 5.00 out of 5
    $201.00
  • Buy Windows 11 Professional MS Products CD Key Buy Windows 11 Professional MS Products CD Key
    Rated 5.00 out of 5
    $6.00
  • AVG Internet Security 2021 1 Device 1 Year Global AVG Internet Security 2021 1 Device 1 Year Global
    Rated 5.00 out of 5
    $11.00
  • Buy Office 2021 Professional Plus Key Global For 5 PC Buy Office 2021 Professional Plus Key Global For 5 PC
    Rated 5.00 out of 5
    $68.00
  • Avast SecureLine VPN 2021 2 Years 5 Devices Global Avast SecureLine VPN 2021 2 Years 5 Devices Global
    Rated 5.00 out of 5
    $47.00
Products
  • Buy Microsoft Office Professional Plus 2019 CD Key Global - 5 PC Buy Microsoft Office Professional Plus 2019 CD Key Global - 5 PC
    Rated 4.95 out of 5
    $32.00
  • Avast Ultimate Suite 2021 2 Years 10 Devices Global Avast Ultimate Suite 2021 2 Years 10 Devices Global
    Rated 5.00 out of 5
    $77.00
  • Windows Server 2022 Remote Desktop Services Device Connections (50) Cal Key Global Windows Server 2022 Remote Desktop Services Device Connections (50) Cal Key Global
    Rated 5.00 out of 5
    $22.00
  • Windows Server 2016 Standard Key Global Windows Server 2016 Standard Key Global
    Rated 4.80 out of 5
    $10.00
  • Buy Windows 11 Home CD Key Global Buy Windows 11 Home CD Key Global
    Rated 4.73 out of 5
    $6.00
  • Microsoft Project Standard 2019 - 1 PC Microsoft Project Standard 2019 - 1 PC $12.00
  • Microsoft Project 2016 professional CD Key Global Microsoft Project 2016 professional CD Key Global
    Rated 4.97 out of 5
    $9.00
  • Windows Server 2012 R2 Datacenter Key Global Windows Server 2012 R2 Datacenter Key Global
    Rated 4.71 out of 5
    $15.00
  • Microsoft Visual Studio 2019 Professional Key Microsoft Visual Studio 2019 Professional Key
    Rated 4.84 out of 5
    $15.00
  • Microsoft Visual Studio Enterprise 2019 For 1 PC Microsoft Visual Studio Enterprise 2019 For 1 PC
    Rated 4.88 out of 5
    $15.00
Product categories
  • Anti Virus
  • Microsoft Office
  • Microsoft Project
  • Microsoft Visio
  • Microsoft Visual
  • Microsoft Windows
  • Other Software
  • Uncategorized

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.