LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 33
Default list of entries from a column without duplicates

I have a list of materials in column B that may have the same material
listed several times, I would like to create a list of all materials
used in another column without duplicating the same material. I have
tried lists but I can get one material at a time or all of them.
Can anyone help with just a single list of material types?
 
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
How to get pivot table to list duplicate entries in column fields? crcurrie Excel Discussion (Misc queries) 2 March 12th 07 08:48 PM
How do I set a column to list entries in Alphabetic order? lisslou Excel Worksheet Functions 1 October 13th 06 04:05 AM
Insert column entries from a master list RichLorn Excel Worksheet Functions 1 October 28th 04 10:37 PM
Insert column entries from a master list RichLorn Excel Worksheet Functions 0 October 28th 04 08:59 PM
Insert column entries from a master list RichLorn Excel Worksheet Functions 0 October 28th 04 08:57 PM


All times are GMT +1. The time now is 11:40 AM.

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"