Type the first letter of the name and select the name from the list that appears. The whole column is filled with the formula in the cell C6. To create a formula with references highlight the cells you want to use then select an empty cell and enter the formula.
Now select the entire column-This applies even for the Row.
This is the list of numbers in a range or in an array you want to your Number compared to. The Excel COLUMN function returns the column number for a reference. Now select the entire column-This applies even for the Row. Select a cell and enter a formula.