Lookup Functions – Kazam Raza

ROW Function

Posted on January 21, 2024February 24, 2024 by kazamraza

Returns the row number of a reference. 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. If reference is omitted, it is assumed to be the reference of the cell in which the ROW function...

Find the Last Row of data in Excel Using INDEX and COUNTA

Posted on January 15, 2024 by kazamraza

Sometime we have a requirement that we want to fetch data from last cell in a column. This task can be achieve by using INDEX Function (Return the value or reference of the cell at the intersection of particular row and column in a give range) COUNTA Function (Count the number of cell in a...