ROW function - Microsoft Support
The ROW function in Excel returns the row number of a reference you enter in a formula. For example, =ROW(C10) returns row number 10. You can't use this function to insert or remove a row.
Look up values with VLOOKUP, INDEX, or MATCH - Microsoft …
=HLOOKUP(3, {1,2,3;"a","b","c";"d","e","f"}, 2, TRUE) Looks up the number 3 in the three-row array constant, and returns the value from row 2 in the same (in this case, third) column. There are three rows of values in the array constant, each row separated by a semicolon (;).
ROW function - Microsoft Support
This article describes the formula syntax and usage of the ROW function in Microsoft Excel. Description. Returns the row number of a reference. Syntax. ROW([reference]) The ROW function syntax has the following arguments: Reference Optional. The cell or range of cells for which you want the row number.
Using IF with AND, OR, and NOT functions in Excel
In Excel, the IF function allows you to make a logical comparison between a value and what you expect by testing for a condition and returning a result if that condition is True or False.
Apply shading to alternate rows or columns in a worksheet
One way to apply shading to alternate rows or columns in your worksheet is by creating a conditional formatting rule. This rule uses a formula to determine whether a row is even or odd numbered, and then applies the shading accordingly. The formula is shown here: =MOD(ROW(),2)=0
Overview of formulas in Excel - Microsoft Support
The R1C1 reference style is useful for computing row and column positions in macros. In the R1C1 style, Excel indicates the location of a cell with an "R" followed by a row number and a "C" followed by a column number.
Transpose (rotate) data from rows to columns or vice versa
How to use Transpose in Excel to rotate columns and rows to rearrange your worksheet data.
Using structured references with Excel tables - Microsoft Support
When you add formulas to an Excel table, those names can appear automatically as you enter the formula and select the cell references in the table instead of manually entering them. Here's an example of what Excel does: That combination of table and …
Excel functions (alphabetical) - Microsoft Support
Lookup and reference: Looks in the top row of an array and returns the value of the indicated cell. HOUR function. Date and time: Converts a serial number to an hour. HSTACK. Lookup and reference: Appends arrays horizontally and in sequence to return a …
Excel functions (by category) - Microsoft Support
Worksheet functions are categorized by their functionality. Click a category to browse its functions. Or press Ctrl+F to find a function by typing the first few letters or a descriptive word. To get detailed information about a function, click its name in the first column.
Using functions and nested functions in Excel formulas
Functions are predefined formulas that perform calculations by using specific values, called arguments, in a particular order, or structure. Functions can be used to perform simple or complex calculations. You can find all of Excel's functions on the Formulas tab on the Ribbon: