LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
carl
 
Posts: n/a
Default 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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Question about combining data from multiple workbooks into one rep BookOpenandUpright Excel Discussion (Misc queries) 2 February 19th 05 12:37 PM
Indexing, matching and vlookups? inthestands Excel Worksheet Functions 2 February 1st 05 03:21 PM
An easy macro question and one I believe to be a little more diffi TroutKing Excel Worksheet Functions 3 January 18th 05 09:17 PM
Link Question grits75 Excel Worksheet Functions 2 December 28th 04 01:03 PM
end of worksheet question olmedic Excel Worksheet Functions 1 October 29th 04 08:55 PM


All times are GMT +1. The time now is 01:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"