1
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.
Nam G VU
Posted 2012-03-24T15:49:27.620
Reputation: 10 255
This is directly related to the other thread you have going. Why not respond there and ask the relevant question?
– Raystafarian – 2012-03-24T16:51:41.820@Raystafarian It is related. Indeed I'm looking for way to merge quickly and easily if possible – Nam G VU – 2012-03-24T17:12:13.773
1
See my solution in your other thread using INDEX(), ROW() and COUNTA() functions, it is dynamic.
– Jerry Beaucaire – 2012-03-24T19:46:06.473