![]() The result after applying the filter to the first column (office supplies) is shown in the following image.For this, right-click the required column and select “filter by selected cell’s color.” The data is filtered for duplicates. The columns can be filtered to identify the duplicate values.The duplicate cells are highlighted in the data table, as shown in the following image.In the first box on the left side, select “duplicate.” In the “values with” drop-down, select the required color to highlight the duplicate cells. The pop-up window titled “duplicate values” appears.From the drop-down menu, select “highlight cell rules” and click on “duplicate values.” In the Home tab, select “conditional formatting” from the “styles” section. ![]() Select the data range (A1:C13) where duplicates are to be found. ![]() The steps to find the duplicates in excel with the help of conditional formatting are listed as follows:
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |