Home |
Search |
Today's Posts |
#1
|
|||
|
|||
What is a helper column?
I cannot find any information concerning a "helper Column" in the help files.
Could someone point me in the right direction as to how to find and use this "helper column? Thanks, |
#2
|
|||
|
|||
It's not an Excel term, it is more generalised than that.
In essence, it means using a column to store some intermediate results (using a formula say), that can make further -- HTH RP (remove nothere from the email address if mailing direct) "RMPPOD" wrote in message ... I cannot find any information concerning a "helper Column" in the help files. Could someone point me in the right direction as to how to find and use this "helper column? Thanks, |
#3
|
|||
|
|||
Sorry, hit the button too soon.
It's not an Excel term, it is more generalised than that. In essence, it means using a column to store some intermediate results (using a formula say), that can help simplify further formulas. For instance, if you have a complex formula that repeats a certain test, put that test in the helper column, and refer to that in the main formula, making it more readable and maintainable. -- HTH RP (remove nothere from the email address if mailing direct) "RMPPOD" wrote in message ... I cannot find any information concerning a "helper Column" in the help files. Could someone point me in the right direction as to how to find and use this "helper column? Thanks, |
#4
|
|||
|
|||
a helper column can also be use to do a non-standard sort
by putting numbers or other in the helper column then sorting by the helper colunm. I use this to sort by color -----Original Message----- Sorry, hit the button too soon. It's not an Excel term, it is more generalised than that. In essence, it means using a column to store some intermediate results (using a formula say), that can help simplify further formulas. For instance, if you have a complex formula that repeats a certain test, put that test in the helper column, and refer to that in the main formula, making it more readable and maintainable. -- HTH RP (remove nothere from the email address if mailing direct) "RMPPOD" wrote in message ... I cannot find any information concerning a "helper Column" in the help files. Could someone point me in the right direction as to how to find and use this "helper column? Thanks, . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I sort by row instead of by column? | Excel Worksheet Functions | |||
Format cell in column B based on value in the next cell (column c) | Excel Discussion (Misc queries) | |||
what formula do i put for column m = column k minus column l in e. | Excel Discussion (Misc queries) | |||
Copying the contents of a column into a chart | Excel Worksheet Functions | |||
How to calculate the data in excel 2002 including only the last 9. | Excel Worksheet Functions |