Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.