+ Reply to Thread
Results 1 to 2 of 2

Any quick way to keep unique values in the table

  1. 09-07-2020, 04:01 AM #1
    alipezu
    alipezu is offline
    Forum Contributor
    Join Date
    02-12-2014
    Location
    al ain
    MS-Off Ver
    Excel 2016
    Posts
    149

    Any quick way to keep unique values in the table

    Hi All,
    Please help me keep only unique values in the column B and other corresponding columns. There are more than one duplicate records in the table. Help me remove the duplicates and keep unique value based on the Column B.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 09-07-2020, 04:16 AM #2
    Pepe Le Mokko
    Pepe Le Mokko is offline
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,448

    Re: Any quick way to keep unique values in the table

    https://support.microsoft.com/en-us/...e-66a552dc138d
    How to paste Power Query code ( by Olly)
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Insert blank rows above a table based on unique values in one of the columns in the table
    By carlito2002wgn in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-08-2019, 01:06 PM
  2. Insert blank rows above a table based on unique values in one of the columns in the table
    By carlito2002wgn in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-06-2019, 07:52 PM
  3. Creating unique values table from another table
    By Torrel in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-19-2019, 10:28 AM
  4. List unique column values from table in new table
    By PeterBSR in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-25-2018, 09:39 AM
  5. Table with unique ID's but same values, how to filter out on values?
    By oleisbest in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 04-03-2017, 04:03 AM
  6. [SOLVED] search table for unique values return values and corresponding cells to a different sheet
    By thara95 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-01-2017, 09:04 AM
  7. Unique values - table(?)
    By adashiu in forum Excel General
    Replies: 5
    Last Post: 11-26-2008, 06:31 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1