Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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'. |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calling a new function Excel gives me #NAME? | Excel Worksheet Functions | |||
Excel 2003 Slow Function Argument Window | Excel Discussion (Misc queries) | |||
Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
Simplify Vlookup function in Excel | Excel Worksheet Functions | |||
Access Module coded converted to Excel Function | Excel Discussion (Misc queries) |