Vergel’s Excel and Visual Basic Blog

The CELL() Function

March 1st, 2007

Just a quick tip for now. Let’s say you have 1000 rows of unique numbers in column A and you wanted to know the address of the largest number. You could use the CELL() function like this:

=CELL(”address”,OFFSET(A1,MATCH(MAX(A1:A1000),A1:A1000,0)-1,0))

Or let’s say you wanted to know the filename of the current worksheet. You can also use the CELL() function.

=CELL(”filename”,A1)

The formula above will give you the fully qualified file name of the current workbook. If the workbook hasn’t been saved yet, it will return an empty string.

The CELL() function is documented in the Excel help. Search for “CELL() function”.

Posted in Excel, Functions | No Comments