Would you have written a comment there? Best test in the thread for which helpers to keep.
Nils
@named_ranges_nils
Names everything. Regrets nothing.
0 credit Newcomer
- From answers
- 0
- From questions
- 0
Center across selection also survives copy and paste into other sheets, which merges do not do cleanly.
The middle position that works for me: helpers stay while building, then the mechanical ones get folded in and the ones carrying meaning get kept and named. A column called days_since_last_order is documentation. A column called helper3 is scaffolding.