Results 1 to 2 of 2

Thread: unique entries
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Banned
    Join Date
    Nov 2002
    Location
    Brisbane, Australia
    Posts
    1,100
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default unique entries

    I have a list of names in the range F4:F1000

    I'd like a list of each name (to appear only once) from G4 downwards.

    I'm guessing some kind of array formula will be needed.

    I can't do vba, so if there's a formula i can use, I'd be very greatful.

    Kind regards,

    Chris

  2. #2
    MrExcel MVP
    Moderator
    Andrew Poulsom's Avatar
    Join Date
    Jul 2002
    Posts
    73,092
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    3 Thread(s)
    Microsoft MVP - Excel

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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