UNIQUE Function in Excel | DYNAMIC Unique Lists (7 Examples)

[@arunkhanal7208]

Your video is Simply the Awesome and it leaves distinctive addition to the Excel market.
Your video is academically rigorous, intellectually demanding and practically relevant.

[@Computergaga]

Thank you so much, Arun.

[@fouadhoblos3611]

Is it possible to ask a question or submit a request about Excel or Power Query here??

[@Computergaga]

That depends on the question or request. Questions should related to the video.

[@leechinhhua]

Brilliant Alan! So much useful content in this video, and great realistic use cases 👍
Just thinking also about the start of the video, can you use a similar formula to bring back the ones that are not unique? That could be a good way to pick out duplicates without having to use conditional formatting and then filter.

[@Computergaga]

Thank you, Lee.
Sure. I would use the following formula for the task of returning the non unique values.
=UNIQUE(FILTER(tblAttendees[Names],COUNTIFS(tblAttendees[Names],tblAttendees[Names])>1))
The FILTER and COUNTIFS combo will return the names that occur more than once (not unique), and then UNIQUE is used to return a distinct list only. You could throw SORT in there to order them 😊

[@chinmayeesingh9040]

Can we ask queries if we have any????

[@Computergaga]

Related to the video, sure. I'll do my best.

[@IvanCortinas_ES]

Great tutorial. Absolutely necessary to know the possibilities offered by the Excel calculation engine. Thank you Alan!!!

[@Computergaga]

Thank you, Iván.

[@wayneedmondson1065]

Nice one! Thanks Alan!!

[@Computergaga]

Thank you, Wayne.

[@davemason2604]

Great tutorials as always

[@Computergaga]

Thank you, Dave 😊