How to extract unique values in Excel with VBA | VBA Scripting Dictionary Tutorial | Excel VBA

In this video I show how you can extract unique values in Excel with VBA by using Dictionary

#dax #powerbi #except #sqlserver #excel #dataanalysis #dataanalytics #businessintelligence #bi #data #ssas #analysisservices #data #analytics #datascience #dataanalytics #datavisualization #dataanalysis #analyst #data #businessanalytics #bideveloper #bi #analysis #excelfunctions #excelvba #excelformulas

[AntrikshSharma]

I forgot this as I have been using Office 365 for a long time now, but, If you are using an older version of Excel then to get the Unique Value just use this code after creating UDF. Assuming you paste the code in H4

=IF(ROWS(H$4:H4)<=COUNT(UNIQUEVALUES($B$3:$B$21)), INDEX(UNIQUEVALUES($B$3:$B$21), ROWS(H$4:H4)), "")

[nadermounir]

A very nice Video and well explained. Thank you

[darrelldeclaro]

Awesome!!! I have been looking for this for a long now any idea how to start with working on filter and sort. I am using a licensed excel 2016. that do not have the new functions like excel 365. It would amazing to have

[zakimost]

Dear Sir, thx for your video but it is not sorted neither Ascending nor Descending can you tell me how to do it please

[richardson]

It's not working... results will through only one values...pls help on this

[kapiltakkar]

It is not working returning the duplicate values even using the If formula provided in pinned comment.

[surendrapmaurya]

how to use in Two columns data simultaneously ??

[selvarasan.v]

Can this vba code 2010 use add ins in MS Excel?

[sainathg]

Its not working...will the code works for strings also..

[ramkunda]

Can I use the dictionary to copy and paste rows from one set of sheets into another set of sheets? Dictionary will be used to keep track of the current row number in the sheets.