New UNIQUE Function Office365 | Office2021

Опубликовано: 06 Август 2026
на канале: BK's Excel Network (Biru Kolekar)
504
40

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