+ Reply to Thread
Results 1 to 7 of 7

Formula to transfer name list to another sheet but replace the duplicated name

  1. #1
    Registered User
    Join Date
    06-21-2021
    Location
    Makassar
    MS-Off Ver
    2013
    Posts
    9

    Formula to transfer name list to another sheet but replace the duplicated name

    I've post the example workbook below. In the first sheet, it contain name list, in 2nd sheet i want to have formula that copy all the name list in the 1st sheet but remove the duplicated name

    please help, i only need this formula to finish my work
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2016
    Posts
    5,441

    Re: Formula to transfer name list to another sheet but replace the duplicated name

    Try this in A2:

    =IFERROR(INDEX(Sheet1!$A$2:$A$20,MATCH(0,COUNTIF($A$1:A1,Sheet1!$A$2:$A$20),0)),"")

    Confirm with Ctrl+Shift+Enter.

  3. #3
    Registered User
    Join Date
    06-21-2021
    Location
    Makassar
    MS-Off Ver
    2013
    Posts
    9

    Re: Formula to transfer name list to another sheet but replace the duplicated name

    first of all thanks for the help mate, its almost works. there still little problem on the formula.
    here is it..
    Attached Files Attached Files

  4. #4
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2016
    Posts
    5,441

    Re: Formula to transfer name list to another sheet but replace the duplicated name

    The formula in D2:

    =IFERROR(INDEX($A$2:$A$16,MATCH(0,COUNTIF($D$1:D1,$A$2:$A$16),0)),"")

  5. #5
    Registered User
    Join Date
    06-21-2021
    Location
    Makassar
    MS-Off Ver
    2013
    Posts
    9

    Re: Formula to transfer name list to another sheet but replace the duplicated name

    Its done!!!! Thanks for the help

  6. #6
    Registered User
    Join Date
    06-21-2021
    Location
    Makassar
    MS-Off Ver
    2013
    Posts
    9

    Re: Formula to transfer name list to another sheet but replace the duplicated name

    I've used the formula in my main worksheet which my INDEX ARRAY $A$5:$A$20000, my PC was lagging several times

  7. #7
    Registered User
    Join Date
    06-21-2021
    Location
    Makassar
    MS-Off Ver
    2013
    Posts
    9

    Re: Formula to transfer name list to another sheet but replace the duplicated name

    i've passed the thoose problems mate, now one more problem to be solved

    is there any way to using vlookup in vba for transfer data from one sheet to another with only "one" criteria, and if it doesn't meet the criteria it auto jump to next cell,
    here is the explanation :

    in sheet 1 (Data) there's STATUS coulomn that contain 2 criteria (manual and online) which its gonna be look up value and in the sheet2 (Manual) i want the table will fill by only "manual" criteria

    please help me solve this with vba module
    Attached Files Attached Files

+ 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] Replace present formula names with reference data sheet names list
    By Khaldon in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-05-2021, 09:41 AM
  2. Can a macro or something list missing and duplicated data on a seperate sheet.
    By tweacle in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-18-2019, 03:19 PM
  3. Replies: 1
    Last Post: 05-02-2018, 10:33 AM
  4. Finding out whether data from a list is duplicated in multi-sheet excel document
    By LaSalaAzll in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-19-2017, 01:17 PM
  5. transfer data from list box to sheet
    By mido21 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-25-2017, 05:09 PM
  6. Transfer comments from Sheet 1 to Sheet 2 as list
    By Welshandproud1 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-16-2014, 06:52 AM
  7. Replies: 0
    Last Post: 09-27-2005, 09:05 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