Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Normally we define a range bay the row & column of the begin and end cell, e.g. A1:A11

I wonder if there is a way to define the range which has end-of-column marker, e.g. A1:A~ where ~ stands for end-of-column

End-of-column cell is the cell which has the maximum index of row in the current column - the last cell with actual value in the column.

It would be lovely to have this marker in Excel since we can have defined-name range which auto expands whenever the sheet grows.

share|improve this question
This is directly related to the other thread you have going. Why not respond there and ask the relevant question? – Raystafarian Mar 24 '12 at 16:51
@Raystafarian It is related. Indeed I'm looking for way to merge quickly and easily if possible – Nam G VU Mar 24 '12 at 17:12
See my solution in your other thread using INDEX(), ROW() and COUNTA() functions, it is dynamic. – Jerry Beaucaire Mar 24 '12 at 19:46

You must log in to answer this question.

Browse other questions tagged .