P
patrick
i would like for a function to be applied to the entire column how would i do that?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
Jens Thiel
do that?patrick said:i would like for a function to be applied to the entire column how would i
e.g. FUNC(A:A) -- add-in worksheet functions with entire columns are buggy
though.
Jens.
D
Dave Peterson
I read your question as:
I want to apply a function to each cell in the entire column.
If that's true, just insert a nice helper column to the left of the original and
type your formula in row 1.
Then drag that formula down to the bottom of the other column (probably not to
row 65536--just to the bottom of your data).
You could even copy that column and then Paste|Special|Values right over the
original column.
And delete the helper column.
I want to apply a function to each cell in the entire column.
If that's true, just insert a nice helper column to the left of the original and
type your formula in row 1.
Then drag that formula down to the bottom of the other column (probably not to
row 65536--just to the bottom of your data).
You could even copy that column and then Paste|Special|Values right over the
original column.
And delete the helper column.
A
Anders S
Patrick,
- select the range or column where you want the formula entered
- enter the formula in the formula bar
- press Ctrl+Enter
Don't enter the formula in the entire column - 65,000+ rows - if you don't have to, it will make your file unnecessary large.
HTH
Anders Silven
- select the range or column where you want the formula entered
- enter the formula in the formula bar
- press Ctrl+Enter
Don't enter the formula in the entire column - 65,000+ rows - if you don't have to, it will make your file unnecessary large.
HTH
Anders Silven