1. Welcome! Please take a few seconds to create your free account to post threads, make some friends, remove a few ads while surfing and much more. ClutchFans has been bringing fans together to talk Houston Sports since 1996. Join us!

  2. Watching NBA Action
    Come join Clutch as we're watching NBA Play-In Tournament action live ...

    LIVE: NBA Playoffs!
    Dismiss Notice
Welcome LIVE NBA ACTION

Vlookup = Duplicate invoice

Discussion in 'BBS Hangout' started by Luckyazn, Nov 12, 2014.

Tags:
  1. Luckyazn

    Luckyazn Contributing Member

    Joined:
    Jun 23, 2003
    Messages:
    4,375
    Likes Received:
    68
    I have a spreadsheet with 1,400 rows and there is a column for customer and invoice number ect.

    I need to locate all the duplicate invoice number on this spreadsheet and remove them from the file.

    Is there a Vlookup I can do you identify these dups without going through the whole file and removing one by one.

    Thanks,
     
    #1 Luckyazn, Nov 12, 2014
  2. s land balla

    s land balla Contributing Member

    Joined:
    Apr 24, 2001
    Messages:
    6,608
    Likes Received:
    365
    Highlight the data table, go to the Data tab, click on Remove Duplicates under Data Tools, uncheck all columns except for the Invoice Number column, click OK.
     
    #2 s land balla, Nov 12, 2014
(You must log in or sign up to post here.)

Share This Page

Toggle Width
Style
ClutchFans Original

  • About ClutchFans

    Since 1996, ClutchFans has been loud and proud covering the Houston Rockets, helping set an industry standard for team fan sites. The forums have been a home for Houston sports fans as well as basketball fanatics around the globe.

  • Rockets Content

  • Support ClutchFans!

    If you find that ClutchFans is a valuable resource for you, please consider becoming a Supporting Member. Supporting Members can upload photos and attachments directly to their posts, customize their user title and more. Gold Supporters see zero ads!


    Upgrade Now