Formula to a Cell Reference

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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



Regards,

Peo Sjoblom
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sumproduct - cell reference 4
Delete rows based on contents of Col A 0
Excel VBA 1
Refer to a named range indirectly 2
Sumproduct formula problems 2
Locking a cell reference in a formula 1
Refer to other tabs in formula 2
INDIRECT function to reference a named range 2

Back
Top