| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Formula to a Cell Reference
I am looking for the Formula or Function to find a cell reference. The range
will vary in A6 to A160 with adding and deleting of TEXT - names. What I want is to always be able to find the MIDDLE cell within the range of names at any given time in column A. |
|
#2
|
|||
|
|||
|
If there is an even number of text entries you obviously can't get a the
middle cell since there is no middle cell, you can get close and if there are uneven numbers of entries you can get the middle cell =CELL("address",INDEX(A6:A160,CEILING(COUNTA(A6:A1 60)/2,1))) Regards, Peo Sjoblom "gerr" wrote: I am looking for the Formula or Function to find a cell reference. The range will vary in A6 to A160 with adding and deleting of TEXT - names. What I want is to always be able to find the MIDDLE cell within the range of names at any given time in column A. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
| Need formula for sheet & cell reference | Excel Worksheet Functions | |||
| Formula with text and reference to a date cell | Excel Discussion (Misc queries) | |||
| I there an easy way to find out if any formula reference a cell? | New Users to Excel | |||
| GET.CELL | Excel Worksheet Functions | |||
Hybrid Mode
