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
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
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.
first of all thanks for the help mate, its almost works. there still little problem on the formula.
here is it..
The formula in D2:
=IFERROR(INDEX($A$2:$A$16,MATCH(0,COUNTIF($D$1:D1,$A$2:$A$16),0)),"")
Its done!!!! Thanks for the help
I've used the formula in my main worksheet which my INDEX ARRAY $A$5:$A$20000, my PC was lagging several times
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks