Defined Range OFFSET Unique Entries

[MarkCBB]

Hi there,

I am not sure that this is possible to do without creating a Helper column of sorts, But here goes I would like to define a range in the Name manager that only uses the unique entries, and this this will be used in data validation.

so the range is looking at the whole range of data but only populating the unique entries into the Data validation list.

Thanks.

 

[venkat1926]

google search would have given a few choices. one choice is
http://www.ozgrid.com/forum/showthread.php?t=144327&page=1