Uncategorized

Example Related FunctionsEOMONTH NETWORKDAYS To calculate workdays per month, use the EOMONTH function together with the NETWORKDAYS function.In the ...

Example Related FunctionsDATE MONTH YEAR =MONTH(DATE(YEAR(date),2,29))=2If you want to test whether the year of a certain date is a leap year, you can ...

Example Related FunctionsMIN =IF(start<end,MIN(end,upper)-MAX(start,lower),MAX(0,upper-start)+MAX(0,end-lower))ContextYou have a start time and an ...

Example Related FunctionsROWS =ROWS(rng)If you need to count the number of rows in a range, use the ROWS function. In the generic form of the formula ...

Example Related FunctionsIF TRANSPOSE =TRANSPOSE(IF(rng="","",rng))To dynamically transpose a table that contains blanks, you can use an array formula ...

Windows shortcut  End Mac shortcut  Fn→ This shortcut enables and disables "End mode". In End mode, arrow keys move you farther across the ...

Example Related FunctionsINDEX MATCH =INDEX(data,MATCH(val,rows,1),MATCH(val,columns,1))To lookup in value in a table using both rows and columns, you ...

Example Related FunctionsMATCH VLOOKUP =VLOOKUP(lookup_value,table,MATCH(col_name,col_headers,0),0)In most cases, people will hardcode the column index ...

Windows shortcut  CtrlZ Mac shortcut  ⌘Z This shortcut will allow multiple levels of undo; each time you use it Excel will step back one level. ...

Windows shortcut  AltShift← Mac shortcut  ⌘⇧J This shortcut will ungroup selected pivot table items. If you want to ungroup a field, you only need ...

Windows shortcut  AltShift← Mac shortcut  ⌘⇧J This shortcut will ungroup selected rows or selected columns. Select whole rows or columns first ...

Example Related FunctionsVLOOKUP =VLOOKUP(value,IF(test,table1,table2),col,match)To use VLOOKUP to retrieve values from two lookup tables, you can use ...

Excel - Excel Functions - Excel Formulas
Logo