Retain Order but Remove Duplicates

[ssjagger]

Hi, was wondering if anyone can help me with this?

In cell A1 - J1 I have: 9 2 5 2 2 9 3 4 7 5

What I would like is to keep the order that the numbers are in, but remove the duplicates.

With this set of numbers I would end up with, in cell M1 - R1 9 2 5 3 4 7

Thanks

[AZ-XL]

m1 cell
=IFERROR(INDEX($A$1:$J$1,MATCH(0,COUNTIF($L$1:L1,$A$1:$J$1),0)),"")
Hit Ctrl Shift enter
then drag right

[ssjagger]

That works perfect, thanks AZ-XL