+ Reply to Thread
Results 1 to 8 of 8

Remove duplicates by using formula

  1. #1
    Forum Contributor
    Join Date
    01-28-2019
    Location
    Malaysia
    MS-Off Ver
    Office 365
    Posts
    160

    Remove duplicates by using formula

    Any formula which can remove the duplicate on each row which shown in the results on worksheet? Thank you in advance
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    12-01-2020
    Location
    singapore
    MS-Off Ver
    MS2016
    Posts
    35

    Re: Remove duplicates by using formula

    D2
    {=textjoin(" & ",,if(match(a2:c2,a2:c2,)=column(a2:c2),a2:c2,""))}

  3. #3
    Forum Contributor
    Join Date
    01-28-2019
    Location
    Malaysia
    MS-Off Ver
    Office 365
    Posts
    160

    Re: Remove duplicates by using formula

    Sorry it came out an error "You 've entered too few of arguments for this function"

  4. #4
    Registered User
    Join Date
    12-01-2020
    Location
    singapore
    MS-Off Ver
    MS2016
    Posts
    35

    Re: Remove duplicates by using formula

    press CTRL + Shift + Enter at the same time. You should see curly braces {} if it's entered correctly

  5. #5
    Forum Contributor
    Join Date
    01-28-2019
    Location
    Malaysia
    MS-Off Ver
    Office 365
    Posts
    160

    Re: Remove duplicates by using formula

    Sorry it still didnt work for me. Can you apply your formula into the worksheet directly?

  6. #6
    Registered User
    Join Date
    12-01-2020
    Location
    singapore
    MS-Off Ver
    MS2016
    Posts
    35

    Re: Remove duplicates by using formula

    The attachment is here
    Attached Files Attached Files

  7. #7
    Forum Contributor
    Join Date
    01-28-2019
    Location
    Malaysia
    MS-Off Ver
    Office 365
    Posts
    160

    Re: Remove duplicates by using formula

    Thank you for your help

  8. #8
    Forum Contributor
    Join Date
    01-28-2019
    Location
    Malaysia
    MS-Off Ver
    Office 365
    Posts
    160

    Re: Remove duplicates by using formula

    There are error #VALUE shown out when there are blank cell in the group item, how to solve it?
    Last edited by alferd324; 02-09-2021 at 12:24 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Formula to remove immediate duplicates
    By kev_ in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-14-2019, 07:40 AM
  2. Replies: 6
    Last Post: 11-27-2018, 07:17 AM
  3. [SOLVED] Formula to remove duplicates from each row-
    By Taisir in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-02-2016, 04:23 PM
  4. Formula to Remove Duplicates
    By Kandy1084 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-13-2015, 04:36 AM
  5. [SOLVED] Remove Duplicates out of formula
    By amasson in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 04-03-2014, 11:49 AM
  6. [SOLVED] REMOVE duplicates by formula
    By makinmomb in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-13-2014, 07:44 AM
  7. Replies: 2
    Last Post: 03-20-2011, 11:19 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1