New Functions of Office 365 | Office 2021 | Unique | Filter | Sort | Transpose | BK's Excel Network
Following New Functions are come in Office 365 or Office 2021
1] Unique
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).
2] Filter
Syntax
=FILTER (array, include, [if_empty])
Arguments
array - Range or array to filter.
include - Boolean array, supplied as criteria.
if_empty - [optional] Value to return when no results are returned.
3] Sort
Syntax
=SORT (array, [sort_index], [sort_order], [by_col])
Arguments
array - Range or array to sort.
sort_index - [optional] Column index to use for sorting. Default is 1.
sort_order - [optional] 1 = Ascending, -1 = Descending. Default is ascending order.
by_col - [optional] TRUE = sort by column. FALSE = sort by row. Default is FALSE.
4] Transpose
Syntax
=TRANSPOSE (array)
Arguments
array - The array or range of cells to transpose.
Follow us at
Facebook
/ bkexcelnetwork
Instagram
/ bkexcelnetwork
Twitter
/ birukolekar
Telegram
https://t.me/bkexcelnetwork
WhatsApp
https://wa.me/+919762646663?Text=
#Unique #Filter #Sort #Office365 #Transpose #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