View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] benjamin.mangelinckx@telindus.be is offline
external usenet poster
 
Posts: 3
Default all different records of a column containing more than 1 times each record

Hi,

I feel it is quite easy but I don't find it.

I have a file with all my supplier invoices (with a column with the
suppliers name). Each supplier come more than one times in the column
(as there more than one invoice per supplier).

I want to have a list on another sheet with all my different suppliers.
But they have to occur only once.

Thanks a lot for your help

Benjamin