Can someone explain how to use one and when to use one? Also a working example would be great. Thanks.
Can someone explain how to use one and when to use one? Also a working example would be great. Thanks.
Peace of mind is found in some of the strangest places.
Simple example --
Col A contains list of 10 character items and you need to sort them by characters 5-8
Col B could be the helper col with a formula =Mid(A2,5,4)
Sorting Col B will also sort the associated Col A items
Paul
Helper cell should always be used in two situations in my view
- to avoud overly-complex formulae by breaking them down into simpler, intermediate formulae, so as to ease maintainability and auditability
- to improve performance by reducing the number of cells recalculated in the calculation chain
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber