Results 1 to 4 of 4

If one cell is the same as another

Threaded View

  1. #1
    Registered User
    Join Date
    10-13-2008
    Location
    Australia
    Posts
    12

    Question If one cell is the same as another

    I am keeping an email list for my university and there are a few hundred emails on it. Due to the way this works, there are various people who have registered for it twice. And we don't want to send one person the same email multiple times. Since every month it automatically updates itself, it is quite annoying to have to manually look over a few hundred emails to see if any match.

    I can sort them into alphabetical order, which makes it easy, but I was wondering if there were any short cuts out there? So I could identify if any cells in C match any other?

    edit: Just to let you know what I do at the moment, is I make all the 'new' emails that come in every month bold. So when I sort it is easier to look to what has just been added to see if it has been replicated. This works alright but I'd like to know a more permanent and perfect solution.

    Thanks in advance guys,
    discomute
    Last edited by discomute; 10-20-2008 at 10:31 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Protected Formulas
    By georgeeasten in forum Excel General
    Replies: 13
    Last Post: 12-10-2018, 12:47 AM
  2. Conditional Formatting a cell which is showing a %
    By dandavis1 in forum Excel General
    Replies: 2
    Last Post: 09-08-2008, 08:03 AM
  3. Cell linked to a "wandering" cell
    By BigKahuna in forum Excel General
    Replies: 1
    Last Post: 02-29-2008, 12:27 PM
  4. Loss of cell reference
    By roloto in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 05-20-2007, 06:35 PM
  5. Trouble with Excel Formula?
    By Beev in forum Excel General
    Replies: 4
    Last Post: 05-10-2007, 04:26 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1