Hide name in list that have be used

[weridal]

Is there a way to hide used name from a list that have been use?
I am use two list on is a data dependent list here is the formula
=OFFSET(partname,MATCH(C4,PartColumn,0)-1,1,COUNTIF(PartColumn,C4),1)
thnak you guys are awsome

 

[VoG]

See if this helps http://www.contextures.com/xlDataVal03.html