ShareChat
click to see wallet page
search
#excel #excel shortcut key💻 #EXCEL EDUCATION #advance excel #ms excel
excel - 26 Advanced Excel Formulas Formula Pattern SL No Formula Name SUM =SUMA1 A10) ব (2) AVERAGE =AVERAGE(B1 B10) @ =IF(C2>100,"Yes" "No") VLOOKUP =VLOOKUP(D2 42810 2 FALSE) HLOOKUP =HLOOKUP(Sales" A1:D3 2 FALSE) (6) INDEX =INDEX(A2 C5,2. 3) MATCH =MATCH(500 82.810 0) OFFSET (8) =OFFSET A1 2, 3) (9) =TEXT(TODAY() "DD-MMYYYY") TEXT 10) CONCAT =CONCAT(A1 81 C1) TEXTJOIN =TEXTJOIN( TRUE , A2 A5) (11) =UNIQUE(A2 A10) UNIQUE (Excel 365) (12)  =FILTER(A2:810, 82:B10="Yes") (13) FILTER (Excel 365) | (14) SORT Excel 365) =SORT(A2 B10, 2,TRUE) (15) SORTBY (Excel 365) =SORTBY(A2:A10  B2 B10 -1) (16) SEQUENCE (Excel 365) =SEQUENCE(5 1, 1 2) =RANDARRAY(3 2 1 100, TRUE) RANDARRAY (Excel 365) (17) A2A10,B2B10, "NA") (18) XLOOKUP (Excel 365` =XLOOKUP("John" =XMATCH(100, A2 A10, 0) (19) XMATCH (Excel 365) =LAMBDA(X x1०)(५) (20) LAMBDA (Excel 365) =LET(X. A1*2, y x+10, y) (21) LET (Excel 365) =ISNUMBER(A2) ISNUMBER (22) =TODAY() (23) TODAY (24) NETWORKDAYS =NETWORKDAYS(A2 82) (25) YEARFRAC =YEARFRAC(42, 82) A1=2,"Two", TRUE "Other") (26) IFS (Excel 365) =IFS(A1-1 "One" 26 Advanced Excel Formulas Formula Pattern SL No Formula Name SUM =SUMA1 A10) ব (2) AVERAGE =AVERAGE(B1 B10) @ =IF(C2>100,"Yes" "No") VLOOKUP =VLOOKUP(D2 42810 2 FALSE) HLOOKUP =HLOOKUP(Sales" A1:D3 2 FALSE) (6) INDEX =INDEX(A2 C5,2. 3) MATCH =MATCH(500 82.810 0) OFFSET (8) =OFFSET A1 2, 3) (9) =TEXT(TODAY() "DD-MMYYYY") TEXT 10) CONCAT =CONCAT(A1 81 C1) TEXTJOIN =TEXTJOIN( TRUE , A2 A5) (11) =UNIQUE(A2 A10) UNIQUE (Excel 365) (12)  =FILTER(A2:810, 82:B10="Yes") (13) FILTER (Excel 365) | (14) SORT Excel 365) =SORT(A2 B10, 2,TRUE) (15) SORTBY (Excel 365) =SORTBY(A2:A10  B2 B10 -1) (16) SEQUENCE (Excel 365) =SEQUENCE(5 1, 1 2) =RANDARRAY(3 2 1 100, TRUE) RANDARRAY (Excel 365) (17) A2A10,B2B10, "NA") (18) XLOOKUP (Excel 365` =XLOOKUP("John" =XMATCH(100, A2 A10, 0) (19) XMATCH (Excel 365) =LAMBDA(X x1०)(५) (20) LAMBDA (Excel 365) =LET(X. A1*2, y x+10, y) (21) LET (Excel 365) =ISNUMBER(A2) ISNUMBER (22) =TODAY() (23) TODAY (24) NETWORKDAYS =NETWORKDAYS(A2 82) (25) YEARFRAC =YEARFRAC(42, 82) A1=2,"Two", TRUE "Other") (26) IFS (Excel 365) =IFS(A1-1 "One" - ShareChat