Remove duplicates within a row

0 votes

How do I remove duplicates within a row for Excel without using VBA?

What i have:

Row 1: 1 | 1 | 2 | 2 | 3 | 3

What i want:

Row 1: 1 | 2 | 3

Mar 11 in Database by Edureka
• 13,640 points
82 views

1 answer to this question.

0 votes

To check for duplicates, choose the cells you want to check.

Note that duplicates in the Values section of a PivotTable report cannot be highlighted in Excel.

Duplicate Values can be found by going to Home > Conditional Formatting > Highlight Cells Rules > Duplicate Values.

Highlight cell rules

Select the formatting you want to apply to the duplicate values in the box next to values with, and then click OK.

Duplicate Values dialog box

answered Mar 15 by gaurav
• 22,040 points

Related Questions In Database

0 votes
2 answers

How to select the nth row in a SQL database table?

SELECT * FROM ( SELECT ID, NAME, ROW_NUMBER() ...READ MORE

answered Apr 23, 2020 in Database by anand
• 140 points
18,945 views
0 votes
1 answer

Why is there still a row limit in Microsoft Excel?

Because of optimizations, most likely. There are ...READ MORE

answered Mar 30 in Database by gaurav
• 22,040 points
103 views
0 votes
1 answer

Excel formula to remove space between words in a cell

There are three fast techniques to get ...READ MORE

answered Mar 30 in Database by gaurav
• 22,040 points
122 views
0 votes
0 answers

in MS excel find first non n/a value in row

I have dates (Jan-2014 in cell A1, ...READ MORE

Mar 30 in Database by Edureka
• 13,640 points
98 views
0 votes
1 answer
0 votes
1 answer

Remove special characters from the specified string in excel

To erase a specific character from a ...READ MORE

answered Mar 15 in Database by gaurav
• 22,040 points
600 views
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer

Excel formula to remove comma, spaces, period and add a text

The steps to accomplish this are as ...READ MORE

answered Mar 15 in Database by gaurav
• 22,040 points
660 views
0 votes
1 answer

Excel function to return a nested SEQUENCE within COMBIN()

You could do it with a triangular ...READ MORE

answered Mar 25 in Database by gaurav
• 22,040 points
126 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP