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

1. ## 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

2. ## 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. ## 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..

4. ## 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. ## Re: Formula to transfer name list to another sheet but replace the duplicated name

Its done!!!! Thanks for the help

6. ## 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. ## 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

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

#### 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