Mumsnet Moonwatch

Mumsnet Talk

"The country's most popular meeting point for parents" The Times
  Topics | Active | Search  
discountpartnersnew MEMBER DISCOUNTS Get a 10% discount from Boden (inc free delivery and returns). To see all member discounts, click here. Not a member yet? Join Mumsnet for free here. discountpartnersnew

Recipe of the week

penguinmum's creamy fish pie: smoky, seasonal fish in a creamy white sauce with grated, rather than mashed, tatties on top - a meal of the highest comfort-food order.

MN Local

Please login or join Mumsnet first.

Follow mumsnet on...

TwitterFacebookYoutube


Mumsnet Talk


Start new thread within this topic | Watch this thread | Flip this thread |
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 | Contact poster By Tue 03-Nov-09 15:04:16
OH fab. Glad I could help smile
Thanks Norma!

It appears to have hidden duplicates but I've copied and pasted into new spreadsheet and taken total down by about a thousand and now I don't have to make decisions about keeping Mr or Mrs as it has done it for me

Result!
Add message | Report | Contact poster By 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.
Hi

I've downloaded our client database into an exel spreadsheet as I want to mail everyone who has worked with us.

However, our database is crap (in house system) and many people have input various things over the years so I'm doing some serious data cleaning!

Have managed to take out everyone who is a supplier or business contact rather than customer (hilariously, there is no way of disinguishing between these groups in our data, I've cleaned via postcode...)

I'm now left with some 7,000 names and addresses. I only want one letter to go to each household and for the first 500 I have sorted by postcode then address and skimmed down to try and take out duplicate addresses and names (many people have 2-3 records hmm but I can't face doing this for the whole lot!!

Is there a way I can highlight duplicates in the address1 column (number and street) that would allow me to easily get rid of the obvious reoffenders?

Cheers
Add your message here
Message
Nickname:
Password:
To post a message you need a valid mumsnet nickname and password. If you have forgotten your nickname, click here for a reminder. If you are not yet a member of mumsnet, you can join here.

Emphasis: To bold a word, surround it with asterisks, so *hello* will display hello. For underline use _ , so _hello_ gives hello. For italics use ^, so ^hello^ gives hello. To strike out a word, surround it with two hyphens either side, so --dog-- gives dog

Links and smileys: To insert a smiley face,  , type [smile] or :)
For a big grin,  , type [grin] or :o
For a wink,  , type [wink]
For a shocked face,  , type [shock]
For an angry face,  , type [angry]
For an embarrassed face,  , type [blush]
For a sad face,  , type [sad] or :(
For an envious face,  , type [envy]
For a sceptical face,  , type [hmm]
For a no comment face,  , type [biscuit]

Links The simplest way to insert a link is to enter the link itself, surrounded by [[ and ]]. So if you type [[www.mumsnet.com]], the link will display as http://www.mumsnet.com. If you want your link to display text other than the web address itself, leave a space after the address then add the text before the ]]. So "Look at [[www.mumsnet.com this page]]", would display "Look at this page".
Shortcuts