Excel formula needed

frenchie — Thu, 03 Jun 2010 19:42:13 GMT

Hi all.

Can someone help me with this formula please.

Example : I have in row 1 and A B C D E F G H I J

4 4 1 2 7 4 9 5 0 7

I need the formula to remove duplicate

which would give me the result in : L M N O P Q R

0 1 2 4 5 7 9

Thank you.