How do you find duplicates in excel on a mac?



How do you find duplicates in excel on a mac?..

Answer / Vijyanand Kumar

To find duplicates in Excel on a Mac, click on the Data tab, then select 'Filter' and choose 'Advanced Filter'. In the criteria range, enter '=' and then the first unique value for the column you want to check. Check the box that says 'Unique Records Only' and apply filter.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More MS Excel Microsoft Interview Questions

How do you search for names in excel?

1 Answers  


How do I reduce the tab size in excel?

1 Answers  


How do I copy a formula down an entire column?

1 Answers  


Where is countif function in excel?

1 Answers  


Can I see a list of the colorindex and the corresponding color?

1 Answers  


How do I get the ribbon back in excel?

1 Answers  


What is the main difference between goal seek and variable data tables?

1 Answers  


How do I stop excel from automatically opening?

1 Answers  


How do I export from excel?

1 Answers  


What is the main function of spreadsheet?

1 Answers  


How do I open excel 2010 in safe mode?

1 Answers  


How many functions are in excel?

1 Answers  


Categories