| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Matching Question
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. |
|
#2
|
|||
|
|||
|
Datafilteradvanced filter and unique records only, probably easier if you
use copy to another location as well -- Regards, Peo Sjoblom "carl" wrote in message ... 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. |
|
#3
|
|||
|
|||
|
thank. tried this before posting. when i use the advanced filter the new
table has 2 entried for each product. "carl" wrote: 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. |
|
#4
|
|||
|
|||
|
Then they are not unique, it might be something simple like extra spaces or
something -- Regards, Peo Sjoblom "carl" wrote in message ... thank. tried this before posting. when i use the advanced filter the new table has 2 entried for each product. "carl" wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Question about combining data from multiple workbooks into one rep | Excel Discussion (Misc queries) | |||
| Indexing, matching and vlookups? | Excel Worksheet Functions | |||
| An easy macro question and one I believe to be a little more diffi | Excel Worksheet Functions | |||
| Link Question | Excel Worksheet Functions | |||
| end of worksheet question | Excel Worksheet Functions | |||
Hybrid Mode
