What is the fastest way to get a column
New Column( "Row", Formula( Row() ))
1 click = 1 drag&drop = 1 key pressed
Toolbar/add-in/script with such a functionality. Or you can create initialized column after right clicking on the column header
Edit:
If formula is needed New Formula Column context menu should be able to do it
wow, initialized values - very useful!
always something new to learn
The approach via the right click new formula column menu is nice - 4 "clicks" (or mouse movements without clicking).
let's see if anyone can beat that.
By the way, there is no shortcut formula to count the entries in a column, e.g. the :name column, right?
New Column( "count",Numeric,"Continuous", Formula( Col Number( 1, :name ) ));
Seems like Character columns won't let you use Count which would do this when used with Group
strange, isn't it?