This is the New Function in Office 365 or Office 2021
Syntax
=UNIQUE (array, [by_col], [exactly_once])
Arguments
array - Range or array from which to extract unique values.
by_col - [optional] How to compare and extract. By row = FALSE (default); by column = TRUE.
exactly_once - [optional] TRUE = values that occur once, FALSE= all unique values (default).
Follow us at
Facebook
/ bkexcelnetwork
Instagram
/ bkexcelnetwork
Twitter
/ birukolekar
Telegram
https://t.me/bkexcelnetwork
WhatsApp
https://wa.me/+919762646663?Text=
#Unique #office365 #office2021 #XLOOKUP #VLOOKUP #MSExcel #PDF #AdvancePDFCreation #PDFUse #TallyPrime #TallyRelease2.0 #GST #TDS #206AB #TDSonSpecifiedPersons #194Q #TDSonGoods #Budget2021 #ContactRegister #vlookup #lookup #msexcel #autotax #gst #gsteinvoice #audittrail #AuditTrailinTally #TallyPrime #MSExcel #AdvancedExcel #ConditionalFormatting #ERP #PowerPivot #PowerMap #PowerQuery #TallyPrime #TallyUpdate #TallyNewRelease #TallyCourse #TallyOnline #TallyonCloud #Corporate_Trainer #BiruKolekar #TallyExpert #TallySpecialist #TDSonPurchaseofGoods #BKExcelNetwork #BiruKolekar #CorporateTrainer