How to Remove Duplicate Rows in Excel

When you are working with spreadsheets in Microsoft Excel and accidentally copy rows, or if you are making a composite spreadsheet of several others, you will encounter duplicate rows which you need to delete. This can be a very mindless, repetitive, time consuming task, but there are several tricks that make it simpler.

Read More
Find-max-unique-value-from-a-range-that-have-duplicate-numbers-and-blanks1

Find max unique value from a range that have duplicate numbers and blanks

Problem: How to find Min and Max numeric values in a range of cells that have duplicate numbers and blanks, but only want to find the Min and Max on the largest/top 100 non-duplicate values. Solution: Array formula in cell D11: =MAX(IF((COUNTIF(Table1[Value],Table1[Value])<>1)+(Table1[Value]=””),””,Table1[Value])) Array formula in cell D12: =LARGE(IF((COUNTIF(Table1[Value],Table1[Value])<>1)+(Table1[Value]=””),””,Table1[Value]),100) Formula in cell D15: =MAX(Table1[Value]) Formula in […]

Read More
10 Top Excel Keyboard Shortcuts

The 10 most useful Excel keyboard shortcuts

The 10 most useful Excel keyboard shortcuts Why complicate your spreadsheet life with a bunch of tricks you’ll never use? These 10 shortcuts will expedite the Excel tasks you perform every day. It’s great to know the resources are out there. But on a practical level, mastering 10 genuinely useful shortcuts will get you a […]

Read More
How to Highlight Cells with Duplicate Values in a Range

How to Highlight Cells with Duplicate Values in a Range?

How to Highlight Cells with Duplicate Values in a Range? By using Conditional Formatting in Excel we can Highlight Duplicate Cells. Steps to do: ======== Select the Cells/Range you wish to compare Select the Home Tab Select Conditional Formatting Select Highlight Cell Rules Select Duplicate Values Select a Highlight Color Select Okay Tada..!! Magic…  All the […]

Read More
Filter Identify Unique Values or Remove Duplicate Values

Filter/Identify Unique Values or Remove Duplicate Values

Filter/Identify Unique Values or Remove Duplicate Values In Microsoft Office Excel 2007, you have several ways to Filter for Unique Values or Remove Duplicate Values, 3 most commonly used options are listed below: 1 > To highlight unique or duplicate values, use the Conditional Formatting command in the Style group on the Home tab. 2 […]

Read More