Transfer Items to a list with no duplicates

  • Thread starter Thread starter Leaper
  • Start date Start date
L

Leaper

Hi
I'm after generating a list of items from a column of data (the column is
for describing certain model/specification of items in an other column),
The list should be placed else were on the work sheet,
But I only want the list to have one occurrence of each item (no
duplicates, so I can add a value for each model and then use it for a
Vlookup in a calculation.


Thanks in advance for any help
Kev
 
Kev

Use Advanced Filter to select Uniqu Items and copy to another location.

Regards

Trevor
 
You must log in or register to reply here.

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

How to remove duplicated items from a list? 2
Duplicate Item Numbers 7
Validation List 2
List Duplicates 4
create a list of unique values 4
Excel Lookup 1
Sum Values from different column 1
Merge 2 excel worksheets into one and remove duplicate entries. 1

Back
Top