Thread: Find suppliers
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rockbear Rockbear is offline
external usenet poster
 
Posts: 59
Default Find suppliers

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