| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to reference last non-blank cell value from a column cells?
I have a column that contains consequtive cells of real numbers followed by
blank cells. The number of cells with real numbers can change but there are never blank cells mixed in - only blank cells after them. I want to reference the last real number (last non-blank cell) in a predetermined cell. For example: Cells AR19:AR31 will contain the real and blank cells. I want to copy the last non-blank cell from range AR19:AR31 into cell AR 35. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to reference last non-blank cell value from a column cells?
=LOOKUP(2,1/(AR19:AR310),AR19:AR31)
-- Gary''s Student - gsnu200851 "Hal J" wrote: I have a column that contains consequtive cells of real numbers followed by blank cells. The number of cells with real numbers can change but there are never blank cells mixed in - only blank cells after them. I want to reference the last real number (last non-blank cell) in a predetermined cell. For example: Cells AR19:AR31 will contain the real and blank cells. I want to copy the last non-blank cell from range AR19:AR31 into cell AR 35. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to reference last non-blank cell value from a column cells?
I have a column that contains consequtive
cells of real numbers there are never blank cells mixed in One way: =INDEX(AR19:AR31,COUNT(AR19:AR31)) Another way: =LOOKUP(1E100,AR19:AR31) -- Biff Microsoft Excel MVP "Hal J" <Hal wrote in message ... I have a column that contains consequtive cells of real numbers followed by blank cells. The number of cells with real numbers can change but there are never blank cells mixed in - only blank cells after them. I want to reference the last real number (last non-blank cell) in a predetermined cell. For example: Cells AR19:AR31 will contain the real and blank cells. I want to copy the last non-blank cell from range AR19:AR31 into cell AR 35. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to return a blank formula cell if the reference is blank? | Excel Worksheet Functions | |||
| returning blank when reference cell is blank | Excel Worksheet Functions | |||
| Reference blank cells in formula | Excel Discussion (Misc queries) | |||
| how to get excel to display blank if reference cell blank | Excel Worksheet Functions | |||
| COUNT NON-BLANK CELLS WITH REFERENCE TO ANOTHER COLUMN | Excel Worksheet Functions | |||
Hybrid Mode
