|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Search this Thread | Display Modes |
|
#1
May 26th 06, 05:51 PM
posted to microsoft.public.outlook
|
|||
|
|||
duplicate entries
I have a rather large spreadsheet of Names, addresses, etc. I have noticed
that there are many duplicate entries. any suggestions or formulas that would allow me to highlight the duplicates preferably in color, would be much appreciated. Please keep in mind, that I am a beginner with excel, so I need something simple and uncomplicated.......Thanks 
|
| Ads |
|
#2
May 26th 06, 05:55 PM
posted to microsoft.public.outlook
|
|||
|
|||
|
duplicate entries
microsoft.public.excel
"Richard Mahan" wrote in message ... I have a rather large spreadsheet of Names, addresses, etc. I have noticed that there are many duplicate entries. any suggestions or formulas that would allow me to highlight the duplicates preferably in color, would be much appreciated. Please keep in mind, that I am a beginner with excel, so I need something simple and uncomplicated.......Thanks
|
|
#3
May 26th 06, 05:59 PM
posted to microsoft.public.outlook
|
|||
|
|||
|
duplicate entries
"Richard Mahan" wrote in message ... I have a rather large spreadsheet of Names, addresses, etc. I have noticed that there are many duplicate entries. any suggestions or formulas that would allow me to highlight the duplicates Why not just delete them? Data / Filter / Advanced filter / filter in place / unique records only make sure you select the data to search through. or you could move the uniques records to a place further down the sheet As always don't work on your orignal data, make a copy before starting. alan
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| advise of or prevent duplicate entries in calender | qwertykb | Outlook - Calandaring | 0 | May 8th 06 05:26 PM |
| duplicate entries | nkg554 | Outlook - Using Contacts | 3 | May 1st 06 05:56 PM |
| Duplicate Calendar Entries | stevieg | Outlook - Calandaring | 0 | March 24th 06 01:14 AM |
| How can I eliminate duplicate entries in my Contacts folder | RevDuncan | Outlook - Using Contacts | 1 | March 4th 06 03:12 PM |
| Duplicate entries in calendar | Chester1 | Outlook - Calandaring | 1 | January 10th 06 12:38 PM |
Linear Mode
