Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |