is there a "distinct" function native to Excel
 

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.

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.

"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.

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.

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 am no expert, but I had a similar requirement no long ago, and this
worked for me:
With the cursor at the list title -
DataFilterAdvanced 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/09...7/UniqueXL.jpg

Hope this helps

Alex


--
Ingeniero1
------------------------------------------------------------------------
Ingeniero1's Profile: http://www.excelforum.com/member.php...fo&userid=4029
View this thread: http://www.excelforum.com/showthread...hreadid=467214