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
1	List
2	APPLE
3	ORANGE
4	BANANA
5

<colgroup><col style="width: 25pxpx"><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet2​

Array Formulas Cell Formula A2 {=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)),"")} <thead> </thead><tbody> </tbody> Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}. Note: Do not try and enter the {} manually yourself

<tbody>
</tbody>

 

[khanzgem]

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