I have a sheet with duplicated values in the rows
for example:

A B C D E F G H I J
1| 1| 1| 1| 3| 5| 5| 5| 1| 1| 1|
2| 8| 8| 8| 3| 3| 3| 8| 8| 8| 8|

I need to delete all duplicated values in each row
Result

A B C D E F G H I J
1| 1| 3| 5| 1|
2| 8| 3| 8|


--
Oleg


------------------------------------------------------------------------
Oleg's Profile: http://www.excelforum.com/member.php...fo&userid=4004
View this thread: http://www.excelforum.com/showthread...hreadid=520035