Data sorting

Hello Laura,

Finding duplicate data depends on what is stored in each cell, there is a Duplicates option you may try.

Select the column of data you want to check for duplicates.
In the Home Ribbon, Conditional Format button, Highlight Cells Rules, at the bottom is Duplicate values. Click this and see if that works.


I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Mark
Microsoft Office Specialist Trainer