Duplicate removal not in alphabetical order

[masud8956]

Hi,

I am using the following formula in my worksheet:

=IFERROR(INDEX($H$74:$H$783,MATCH(0,COUNTIF($H$74:$H$783,"<"&$H$74:$H$783)-SUM(COUNTIF($H$74:$H$783,F$797:F797)),0)),"")

I am getting the intended list that i want with duplicates removed. But the List is appearing in alphabetical order.

What modification do I need to keep the order unchanged? I want it in the order of input.

I prefer NOT to use VBA.

 

[pike]

could you work with this
with the List in A1 to A19
in F2=LOOKUP(REPT("z",255),CHOOSE({1;2},"",INDEX($A$1:$A$19,MATCH(TRUE,INDEX(ISNA(MATCH($A$1:$A$19,$F$1:$F1,0)),0),0)))) fill down

 

[masud8956]

could you work with this
with the List in A1 to A19
in F2=LOOKUP(REPT("z",255),CHOOSE({1;2},"",INDEX($A$1:$A$19,MATCH(TRUE,INDEX(ISNA(MATCH($A$1:$A$19,$F$1:$F1,0)),0),0)))) fill down

Thank you very much for the quick reply!!

The formula worked beautifully. Only one problem though. I have got a blank cell in between the listed items. Like:

A
B

C
D
E

So, C is returned but after a blanked row. I forgot to mention that in my list between A1 and A19 I have some blank cells and those blanks are necessary.

Thanks in advance!!

 

[kvsrinivasamurthy]

If Formula is in F798

=IFERROR(INDEX($H$74:$H$783,SMALL(IF((COUNTIF(F$797:F797,$H$74:$H$783)=0)*($H$74:$H$783<>0),ROW($H$74:$H$783),""),1)-ROW($H$74)+1),"")

 

[masud8956]

If Formula is in F798

=IFERROR(INDEX($H$74:$H$783,SMALL(IF((COUNTIF(F$797:F797,$H$74:$H$783)=0)*($H$74:$H$783<>0),ROW($H$74:$H$783),""),1)-ROW($H$74)+1),"")

Thank you very much! Worked perfectly okay!