Excel: Combine the awesome UNIQUE and SORT functions in Excel

[@britishagent]

Simple and marvellous in execution.

[@ChrisMenardTraining]

Thank you!

[@tradz4199]

Great video...really like how you are pushing the limit with using unique.

[@ChrisMenardTraining]

Thank you! Unique is becoming one of my favorite functions.

[@janpantera380]

Fantastic Video. Clear and to the point.

[@pandharinathjoshi6565]

Very neat explanation sir

[@ChrisMenardTraining]

Thank you.

[@TheMrRomely]

You are a blessing sir!

[@ChrisMenardTraining]

Thank you kindly

[@edvardremberg3634]

Awesome -didn't know it existed.

[@ChrisMenardTraining]

Cool functions.

[@docvigo]

great video Chris, is there a way to create a list of non-uniques ie: a list of all values that are duplicates.

[@fabiely7]

New subscriber!!! thank you!!!

[@ChrisMenardTraining]

Thanks for subbing!

[@GeorgeAJululian]

Thank you very useful

[@ChrisMenardTraining]

You're welcome.

[@LindsayDavis-s2h]

I'm trying to use the =SORT(UNIQUE) function in a drop-down list on worksheet A that evaluates data in a table on worksheet B (same workbook) but keep getting the response that it evaluates to an error. It works in a cell but not when I try to do a drop-down list. I have over 50 unique values - is this the issue?

[@darylellis7597]

Hello - I'm looking for a way to find the maximum TEXT value within a filtered table.. However, I have learned that finding a maximun text value not allowed? I was then hoping to use the unique function within a filtered excel table but that pulls in all unque values. Any thoughts.

[@jsofrehfood2786]

Hi Chris, thanks for sharing this. I’ve currently got two columns e, f. - e with unique from table; f with countif sorted by largest to lowest amounts. Is there any way to sort unique by the order of countif data in f? Thank you!

[@Joda-es5xd]

Hi, how can we get the total number of the unique value by name? For example Aflac In count 2.

[@RIPChrisNazir]

how can I use unique and sort together for time, I used the same as advised but it doesnt sort the hours, it should start from 12:00AM

[@ChrisMenardTraining]

Here was a test I did. It seems to work. www.screencast.com/t/RhsJRAWzC

[@ubaidillahmuhammad20]

nice. May I have its file.?? put in the description

[@ChrisMenardTraining]

The file is in my blog post located here. chrismenardtraining.com/post/excel-unique-and-sort-functions

[@tamersalem7542]

How are you my dear sir, may God keep you for us, thank you for your interest in spreading science, please help me get a solution to a problem regarding the unique function that you want to use with history so that if there is a table with names and in a history and needs to make a unique function according to the chosen date thank you very very much

[@OOAK-Ireland]

sorry but this nothing more than databasing. For me excel means calculations. What if you add all the amounts from every unique company? you should have two columns: company and the number of total values. I want the new array then sorted by the total values.