Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hello!
I have data in a single row array. The data is not contiguous such that there are holes in the data. Several cells may be blank in the first few cells, in the middle cells, or in the last cells. I need to identify which cell is the one where the data begins. In addition, I need to identify which cell is the one where the data ends. It is not necessary to locate "holes" in the data set. I would like to use functions only to identify these first and last cells. Thank you very much!! Tom |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Referencing last populated cell in a column | Excel Worksheet Functions | |||
formula for a cell which is blank returns populated cell | Excel Discussion (Misc queries) | |||
How do I hide a row in excel if a certain other cell is populated | Excel Worksheet Functions | |||
Index heading when cell is populated | Excel Worksheet Functions | |||
Check to see if a cell is populated | Excel Worksheet Functions |