Forum Discussion
Bazz02
Sep 17, 2021Copper Contributor
excel in windows 10.
how to create a button that sorts by one column and then assigns an order in another column from one to 20.
- Sep 17, 2021Hi, What do you mean by 'order from 1 to 20'? What is 1, what is 30? Kind regards Hans
SergeiBaklan
Sep 28, 2021MVP
IMHO, that's always the risk to use the tool by the way it's not designed for. Structured table assumes same formula for entire column and keeps it as default formula for the column in background.
bosinander
Sep 29, 2021Steel Contributor
Definately prefer structured tables 🙂
When it comes to calculated columns it may be a safer approach to simply delete the column and make a new one. Ctrl+Space and Ctrl+- (minus) and possibly Ctrl++ comes handy.
When it comes to calculated columns it may be a safer approach to simply delete the column and make a new one. Ctrl+Space and Ctrl+- (minus) and possibly Ctrl++ comes handy.