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)
Awesome!!! I have been looking for this for a long time!!!!! 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 that!!!!!!
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.
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)
Please send addin file
not working..
@@robertjansindo4132 What's the issue that you are facing?
A very nice Video and well explained. Thank you
Awesome!!! I have been looking for this for a long time!!!!! 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 that!!!!!!
Agreed, Excel 365 is years ahead of other versions, with so many array functions Excel is a beast.
Can this vba code 2010 use add ins in MS Excel?
how to use in Two columns data simultaneously ??
It's not working... results will through only one values...pls help on this
That's because you may not be using Office 365, please check the pinned comment.
Dear Sir, thx for your video but it is not sorted neither Ascending nor Descending can you tell me how to do it please
It is not working returning the duplicate values even using the If formula provided in pinned comment.
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.
Using Dictionary for just copy paste is overkill, you can simply use Array for that, I can create a video on that if you want.
Its not working...will the code works for strings also..
How to make it power query
Returns just 1 value in 2007 version