HI
I have one sheet from each of the transporters

E3 has adress of the supplier
E4 has country of the supplier

I used remove duplicates, and got the list of suppliers, copied it and
clicked the regret button, that worked fine, but not very stylish :)

--
Just a regular user


ShaneDevenshire skrev:

Hi,

You're not getting a response because you question is not clear. Where are
the transporters? What do you want the output to look like, please show us.
What's happening between E2 and E5?

--
Thanks,
Shane Devenshire


"Rockbear" wrote:

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