is there a "distinct" function native to Excel

C

Chrynoble

I am looking for a function, that does not rely on vb code behind the scene,
that will return only the unique values from a column. This function would in
all ways be similar to the "Distinct" function in SQL.
 
C

Chrynoble

Just for further clarification, I am attempting to use the list feature found
in the validation area. The list can be set to a range, or a formula. I would
like a formula that returns only the distinct values of a column, but it must
return them all.
 
H

Harlan Grove

Chrynoble wrote...
I am looking for a function, that does not rely on vb code behind the scene,
that will return only the unique values from a column. This function would in
all ways be similar to the "Distinct" function in SQL.
Click to expand...

There's no function that could be used in cell formulas, but Advanced
Filters (Data > Filter > Advanced) includes what it calls 'unique
values only'.
 
I

Ingeniero1

I am no expert, but I had a similar requirement no long ago, and thi
worked for me:
With the cursor at the list title -
Data>Filter>Advanced Filter,
• Select [Copy to another location]
• Select [Unique records only]
• Enter cell for the top of the list where unique entries will display
• Click OK
More or less as shown here in three steps (hope it comes through):
http://img.photobucket.com/albums/0903/bonifacio7/UniqueXL.jpg

Hope this helps

Ale
 
Top