In this video, I have explained in detail Microsoft 365 new dynamic array Function #UNIQUE.
The UNIQUE function is an Excel Dynamic Arrays family function and it's available in Microsoft 365 and Office 2021. This function works the same as #Remove_Duplicate tools that remove all those records which are present more than once in a column. But this unique function provides unique list of vertical or horizontal arrays.
To know more about it watch this video till the end.
Subscribe to YouTube & Follow on Facebook Page👇
/ exceluniverse
www.facebook.com/exceluniverse.in
Download Practice File Here👇
https://mega.nz/file/l7o3kLSI#USNgQ_A...
also, watch
Filter Function in Excel👇
• Filter Function in Excel - Best Way o...
Transpose Function👇
• Transpose Function in Excel in Hindi
XLOOKUP Function👇
• How to Use XLOOKUP in Excel
#UNIQUE
#distinct
#microsoft365
#dynamicarray