Matching Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table that lists out all my products:

Product Type
BOX050 ABC
BOX050 ABC
BOX050 ABC
BOX060 EFG
BOX060 EFG
BOX060 EFG
BOX060 EFG
BOX355 HIJ
BOX549 KLM
BOX549 KLM

I would like to create the following table that list out the unique products.

Product Type
BOX050 ABC
BOX060 EFG
BOX355 HIJ
BOX549 KLM

Is there a formula that I can use in ColB of this table that will look at
the first tabvle and display the Type.

Thank you in advance.
 
Data>filter>advanced filter and unique records only, probably easier if you
use copy to another location as well
 
thank. tried this before posting. when i use the advanced filter the new
table has 2 entried for each product.
 
Then they are not unique, it might be something simple like extra spaces or
something
 

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

Match or Index Question 2
Comparing 2 Tables 6
Concatenation Problem / VBA ? 5
Creating A New Table 4
Using Conditional Formating / 4
Index/Match ? 2
Complex LookUp / Match Problem ?? 2
INDEX OR MATCH 2

Back
Top