1. There's a sample file here that uses formulas to extract
unique items from a list:

http://www.contextures.com/excelfiles.html

Under Functions, look for 'Extract Items with Formulas'

2. There are instructions here for creating dependent data
validation lists:

http://www.contextures.com/xlDataVal02.html

wiwi < wrote:
I have a book that contain two sheets (Costing & Accessories).
My Problem are
1.how to hide the duplicate data in Data Validation ?
In Costing sheet, in column B18:B31 use Data-Validation-List-Source
=AccCategory (range name for Accessories sheet column category).
Because Accessories sheet is a table data then may have a duplicate
data in Category field. How to hide the duplicate data and only show
single data when in Data Validation ?

2. filter selection into another combobox
what I'm select in B18 then will filterlist into C18. e.g in B18 is
"Drawcord" then in C18 only show "Drawcord" data for user to select.
When user select the data, all the other field like curr,qty,supplier
will get the data from the selected record of C18


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html