![]() ![]() ![]() In the Select Duplicate & Unique Cells dialog, check Duplicates (Except 1st one) or All duplicates (Including 1st one) options as you need, and go to Processing of results section to specify the highlighting color and font color. Click Kutools > Select Tools > Select Duplicate & Unique Cells, see screenshot: 3. Select the data range, click Kutools > Select > Select Duplicate & Unique Cells. ![]() Area Chart 1 Argument 1 Autofill 2 AVERAGE 3 bar 3 Bar Chart 3 before 1 begin 1 Below 1 between 3 Bevel 1 blank 2 Bold 2 Border 3 Bottom 3 Calendar 1 caption 1 Category 1 Cell 75 Cell Address 13 Cell Range 8 Cells 1 Changing Number of Sheets While Creating New Workbook 1 CHAR 1 character 2 Chart 9 choose 1 Clear 1 Code 1 Color 12 Column 27 COLUMNS 1 Command 14 Comment 6 Concatenate 2 condition 2 conditional formatting 20 Constant 3 contain 1 content 1 convert 1 Copy 6 COUnt 2 COUNT AVERAGE 1 COUNTA 1 Currency 3 current region 2 curret array 2 Custom 4 Customize 2 Cut 1 Data 7 Data Validation 7 Date 16 Date Format 3 DATEDIF 2 Day 4 decimal 6 Decrease Font Size 1 Delete 3 Denominator 1 dependent 2 Design 6 Developer Tab 3 dialog box 4 Dollar 1 Doughnut Chart 1 Drop-Down 4 Duplicate 3 Edit 1 end 1 Entry 1 equal 3 Excel 136 FACT 1 field 1 file 1 File Name 1 Fill 5 Fill Color 6 Fill Series 1 Filter 8 Find 3 Font 3 Font Color 4 Font Size 1 Font Styles 1 Format 20 formats 1 Formula 18 Formula Bar 5 fraction 1 Fraction Format 1 Freeze 1 Function 43 General 1 Glow 1 GoTo 3 Graphic 2 greater 2 Greater values 1 Gridlines 1 Group 15 Growth 2 Header 3 height 1 Hide 6 Highlight 8 HLOOKUP 1 Hour 1 hyperlink 1 Icon 2 If 2 Image 1 Increase Font Size 1 Index 1 Insert 21 Insert Function 3 INT 2 Italic 1 Keyboard 2 Launcher 1 Layout 1 Left 2 Lenght 2 less 2 Line 2 Line Chart 1 Linear 2 Link 1 List 3 Logical Function 4 lower 2 macro 2 Match 1 Maths 8 MAX 2 Merge 3 MID 1 MIN 2 Mixed Reference 1 Month 5 Move 3 Multiple 3 Name Box 5 negative 1 New 1 Next 1 None 1 NOW 1 Number 8 Object 4 OFFSET 1 OR Function 1 Organizatio Chart 1 Orientation 1 Paste 3 Percentage 2 PI 1 Picture 2 Pie Chart 1 Pivot Table 2 POWER 1 precedent 2 Preview 1 Previous 1 Product 2 property 2 Protect 1 quarter 1 Quick Access Toolbar 1 R1C1 Reference 1 RAND 2 RANDBETWEEN 1 Range 5 reference 1 Reflection 1 Relative Reference 1 Rename 2 Replace 1 REPT 1 Restrict 1 Ribbon 4 right 1 Row 23 ROWS 1 Rule 1 sample 1 scientific 2 Second 1 Select 4 Selection Pane 1 Shadow 1 shape 3 Sheet 10 Shortcut 3 Shortcut. Select the range that you want to remove the duplicate rows. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |