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

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 ...

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 FunctionsIF TRANSPOSE =TRANSPOSE(IF(rng="","",rng))To dynamically transpose a table that contains blanks, you can use an array formula ...

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 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 FunctionsCOLUMNS =COLUMNS(rng)If you need to count the number of columns in a range, use the COLUMNS function. In the generic form of ...

Example Related FunctionsCOLUMNS ROWS =ROWS(rng)*COLUMNS(rng)If you need to count the total number of cells in a rectangular range, you can do so with ...

Windows shortcut  ScrLk Mac shortcut  Fn⇧F14 This shortcut toggles Scroll Lock on and off. Note: the Scroll Lock status message may or may not be ...

Windows shortcut  Space Mac shortcut  Space This shortcut will toggle check and uncheck the checkbox for fields listed in the pivot table field ...