Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Jun 2002
    Location
    Durham, North Carolina, USA
    Posts
    140
    Thanks
    5
    Thanked 1 Time in 1 Post

    Display unique values (Excel XP)

    Hi everyone,

    I have a list of names in Column A and I need to send an email to everyone on the list. Many of the names are duplicated and (of course) I only want to send the email to each person once. Is there a way to have Excel display (or filter) only unique values?

    If only my stupid company would let me use Access here at work! I'd have this thing done in a second.

    Thanks in advance,

    Beej

  2. #2
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Display unique values (Excel XP)

    Hi Beej

    You can use the Advanced Filter Option which allows you to create a unique list

    Click Data | Filter | Advanced Filter...
    Jerry

Posting Permissions

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