Forum home » Delegate support and help forum » Microsoft Excel Training and help » Data sorting
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Data sorting
Resolved · Low Priority · Version 2008 (Mac)
Reply Mon 7 Nov 2011, 16:17Delegate Laura said...
Laura has attended:
Excel Introduction course
Data sorting
Hello
If I have a lot of non numerical cells, is there a way of highlighting them all and finding out if there are any duplicates?
The sort function wouldn't work as the data in each cell is quite lengthly, so its not easily detectable.
If there is a quicker way to look, rather than going through each comment that would be great (i have over 200 cells of qualitative data)
Many thanks
For upcoming training course dates see: Pricing & availability
RE: 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
|