Computer Science, asked by vijayna911, 1 year ago

How can we find duplicates in excel?

Answers

Answered by SynysterGates

To do so:

Select the range of cells you wish to test. ...On Excel's Home tab, choose Conditional Formatting, Highlight Cells Rules, and then Duplicate Values.Click OK within the Duplicate Values dialog box to identify the duplicate values.Duplicate values in the list will now be identified.

Previous Question

Next Question

Similar questions

History, 7 months ago

Explain the concept: Sagargote ...

English, 7 months ago

What brought in settled life for early man?

Social Sciences, 7 months ago

Petroleum is called 'black gold and trees are called green gold. Why? hots...

Computer Science, 1 year ago

How can we find mac address of laptop?

Computer Science, 1 year ago

Write a program to find the addition of two numbers in c.

Math, 1 year ago

any 10 questions based on Pythagoras theorem for class 8 with answers...

Computer Science, 1 year ago

Can you say me the match the following and identify the name of given picture. Please send for me I will mark as brainliest...

History, 1 year ago

how long can a minister stay in office...