You need to reword this for us to get a clearer picture. We have no idea
what 'trasporter' refers to.
Please try your question again as we do wish to help
best wishes

--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Rockbear" wrote in message
...
Hi

I have a sheet from our trasporter and in column E there is multible
suppliers, but
one transporter
I need to find witch supplier the transporter transport from.
Column E
Supplier
E2 Mini
E5 Spa
E8 ITR
E11 SRL
E14 Fast
E17 INI

and it goes on to row 1600

There can be many rows with supplier mini but I want each supplier listed
only once, even if its in many rows in E

Is this possible??

Rock

--
Just a regular user