ShareChat
click to see wallet page
search
Ꭾrΐyคnka82❥ - Author on ShareChat: Funny, Romantic, Videos, Shayari, Quotes
Ꭾrΐyคnka82❥
830 ने देखा
•
3 महीने पहले
#excel shortcut key💻 #advance excel group by tech gyan amit
excel shortcut key💻 - Top Excel Formulas S.N Formula Name Formula Pattern SUM =SUM(A1:A10| AVERAGE 'AVERAGE(B1.810) =IF(C2-100,"Yes No") VLOOKUP =VLOOKUP(D2 A2B1O 2 FALSE) =HLOOKUP( Sales", A1:D3, 2, FALSE) HLOOKUP INDEX =INDEX(A2:C5 2, 3) MATCH =MATCH(500, 82:810, 0| =0FFSET(A1, 2, 3) OFFSET =TEXT(TODAY( DD MMYYYY ) TEXT =CONCAT(A1, CONCAT C1) 81 TEXTJOIN =TEXTJOIN( TRUE ^2:A5) UNIQUE (Excel 365) =UNIOUE(A2:A1O) FILTER (Excel 365) =FILTER(A2:B1O, B2:B10="Yes ) 14 SORT (Excel 365) =SORT(A2:B1O 2,TRUE) SORTBY (Excel 365) =SORTBY(A2:A10, 82:B10, -1) SEQUENCE (Excel 365) =SEOUENCE(5 1 1 2) 16 =RANDARRAY(3, 2, 1, 100, TRUE) RANDARRAY (Excel 365) =XLOOKUPI John , ^2:A10, B2:B1O NA ) XLOOKUP (Excel 365) XMATCH (Excel 365) =XMATCH 100, 42:410, 0| =LAMBDA(x, **10)(5) LAMBDA (Excel 365) =LET(x, A1*2, y X+10, y) LET (Excel 365) FISNUMBER(A2) 22 ISNUMBER =TODAY() 23 TODAY NETWORKDAYS =NETWORKDAYSI12 821 24 YEARFRAC =٧EARFRAC(A2, B2) 25 IFS (Excel 365) =|FS(A1=1, One, 41=2, Two , TRUE Other ) 26 Top Excel Formulas S.N Formula Name Formula Pattern SUM =SUM(A1:A10| AVERAGE 'AVERAGE(B1.810) =IF(C2-100,"Yes No") VLOOKUP =VLOOKUP(D2 A2B1O 2 FALSE) =HLOOKUP( Sales", A1:D3, 2, FALSE) HLOOKUP INDEX =INDEX(A2:C5 2, 3) MATCH =MATCH(500, 82:810, 0| =0FFSET(A1, 2, 3) OFFSET =TEXT(TODAY( DD MMYYYY ) TEXT =CONCAT(A1, CONCAT C1) 81 TEXTJOIN =TEXTJOIN( TRUE ^2:A5) UNIQUE (Excel 365) =UNIOUE(A2:A1O) FILTER (Excel 365) =FILTER(A2:B1O, B2:B10="Yes ) 14 SORT (Excel 365) =SORT(A2:B1O 2,TRUE) SORTBY (Excel 365) =SORTBY(A2:A10, 82:B10, -1) SEQUENCE (Excel 365) =SEOUENCE(5 1 1 2) 16 =RANDARRAY(3, 2, 1, 100, TRUE) RANDARRAY (Excel 365) =XLOOKUPI John , ^2:A10, B2:B1O NA ) XLOOKUP (Excel 365) XMATCH (Excel 365) =XMATCH 100, 42:410, 0| =LAMBDA(x, **10)(5) LAMBDA (Excel 365) =LET(x, A1*2, y X+10, y) LET (Excel 365) FISNUMBER(A2) 22 ISNUMBER =TODAY() 23 TODAY NETWORKDAYS =NETWORKDAYSI12 821 24 YEARFRAC =٧EARFRAC(A2, B2) 25 IFS (Excel 365) =|FS(A1=1, One, 41=2, Two , TRUE Other ) 26 - ShareChat