In this video, I have explained about #UNIQUE function that was introduced in the Microsoft365 version and is now available in Microsoft 2021 version also. The unique function works the same as #Remove_Duplicate tools that remove all those records which are present more than once in a column. Also if you want unique records from inside multiple ranges then the unique function will not work directly, for that here I have used the #FILTERXML and #SUBSTITUTE functions.
To know more in detail watch this video till the end
Subscribe to YouTube & Follow on Facebook Page👇
https://www.YouTube.com/exceluniverse
www.facebook.com/exceluniverse.in
Checkout Some Other Excel Tutorials Videos:
FILTERXML Function👇
https://youtu.be/CJ2PAV6BPwY
Extract Unique List Using Formula👇
https://youtu.be/2FHavILdzuU
UNIQUE Function in Excel👇
https://youtu.be/N4k5_hiB9fA
ValueToText and ArrayToText Function👇
https://youtu.be/peLTmiNNzXQ
