Hide
Mumsnet
Start new thread in this topic | Flip this thread | Refresh the display
Add a message

Exel - How do I find and highlight duplicate cells so I can decide if I want to delete them?

(4 Posts)
Add message | Report | Message poster
itwascertainlyasurprise Tue 03-Nov-09 13:36:01

Message withdrawn

Add message | Report | Message poster
NormaStanleyFletcher Tue 03-Nov-09 13:42:25

Cut and paste from help - don't know if it helps though

Select the column or click a cell in the range or list you want to filter.
On the Data menu, point to Filter, and then click Advanced Filter.
Do one of the following.
To filter the range or list in place, similar to using AutoFilter, click Filter the list, in-place.
To copy the results of the filter to another location, click Copy to another location. Then, in the Copy To box, enter a cell reference.
To select a cell, click Collapse Dialog to temporarily hide the dialog box. Select the cell on the worksheet, and then press Expand Dialog .

Select the Unique records only check box.
Note Once you filter for unique values, you can copy them to another worksheet and then archive or delete the original worksheet.

Add message | Report | Message poster
itwascertainlyasurprise Tue 03-Nov-09 14:00:03

Message withdrawn

Add message | Report | Message poster
NormaStanleyFletcher Tue 03-Nov-09 15:04:16

OH fab. Glad I could help smile

Start new thread in this topic | Flip this thread | Refresh the display
Add a message

Add your message here

To post you need a valid nickname and password. Log in if you are a returning member, or join for free.

If you have forgotten your nickname or your password, you can get a reminder.

Talk: Customise | Unanswered messages | Getting started | Acronyms | FAQs
Threads: Active | I'm on | I'm watching | I started | Last 15 minutes | Last hour | Last Day