all different records of a column containing more than 1 times each record

  • Thread starter benjamin.mangelinckx
  • Start date
B

benjamin.mangelinckx

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Group List by Values in Column A and combine related row values inColumn B into 1 Cell 7
Macro/VBA to loop through list of values and output row- Help Need 6
Automatic new worksheet creation at each change of value in a first worksheet 2
Using vlookup to populate multiple rows at once 5
Linked Records? 1
Splitting & Listing Unique values from cells 6
change Data from column b into row based on value in column a 1
Dynamic Dropdown list During Data Entry 3

Top