Copy Unique Item from One Sheet to Other Sheet

[khanzgem]

I have One sheet which have one ITEM many times
for example

I need a formula which copy UNIQUE Item ONE time to Other sheet.

Example
One Sheet
APPLE
APPLE
APPLE
ORANGE
ORANGE
BANANA

Other Sheet
APPLE
ORANGE
BANANA

 

[Eric W]

If your original list is on Sheet1!A2:A10 (I put a header in A1), then you can do this on Sheet2:

	A
List
APPLE
ORANGE
BANANA

<colgroup><col style="width: 25pxpx"><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]

[TD="align: center"]2[/TD]

[TD="align: center"]3[/TD]

[TD="align: center"]4[/TD]

[TD="align: center"]5[/TD]

</tbody>

Sheet2​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Array Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]A2[/TH]
[TD="align: left"]{=IFERROR(INDEX(Sheet1!$A$2:$A$10,SMALL(IF(Sheet1!$A$2:$A$10<>"",IF(COUNTIF($A$1:$A1,Sheet1!$A$2:$A$10)=0,ROW(Sheet1!$A$2:$A$10)-ROW(Sheet1!$A$2)+1)),1)),"")}[/TD]
[/TR]
</tbody>[/TABLE]
Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}.
Note: Do not try and enter the {} manually yourself[/TD]
[/TR]
</tbody>[/TABLE]

 

[khanzgem]

Thank You Eric to Help me.
The Formula Works, Nice.