Duplicates

Hi Raj


Thank you for your question regarding duplicate data.

The are two ways to achieve this. The first is to conditionally format the data:

- Select the column of data i.e. select column A

- Open the 'Format' menu and select 'Conditional Formatting'

- With the Conditional formatting dialogue box open select:
'Cell Value' from the first drop down menu
'Equal to' from the second drop down menu
Type the company name in to the last text box

- Now, click the 'Format' button and select the relevant formatting options

- Click OK and the cells that contain that particular company name will be formatted.

The other method would be to filter out only the unique records from the list, to do this:

- Open the 'Data' menu, selecting 'Advanced Filter'

- Select the 'Copy to another location' button

- In the 'List Range' text box select column A's data

- in the 'Copy to' text box select an empty cell of where you would like the unique records to start from i.e cell reference F1

- Ensure the the 'Unique records only' tick box is checked and then click OK.

This should now present a list of all the unique company records.


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.



Kind Regards,


Nafeesa

Microsoft Office Specialist Trainer