Formula to a Cell Reference

[gerr]

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.

 

[Peo Sjoblom]

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:A160)/2,1)))



Regards,

Peo Sjoblom