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.

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.