E
Ed
How do you set a function for the complete coluum in Excel sheet without
having to go to each individual line?
having to go to each individual line?
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.
M
MageeStringer
you would probably need a VBA code, what do you want this function to
do?
do?
D
Dan
On a Mac it involves entering a formula with appleCmnd-return, on a PC, it
is (I am guessing) wndCmnd-return...
The xls help section is complete on this. Search "array functions"
Dan
is (I am guessing) wndCmnd-return...
The xls help section is complete on this. Search "array functions"
Dan
B
Bob Phillips
Use an array perhaps, such as
=SUM(A:A)
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
=SUM(A:A)
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
E
Ed
I want to take the number in one coluum and multiply it by a number in
another coluum and I want this functionl the same in each row on the spread
sheet without having to go to each row and set up the function. Is there a
way to set the two coluums up at the top for the complete spread sheet
without setting up each row individually?
another coluum and I want this functionl the same in each row on the spread
sheet without having to go to each row and set up the function. Is there a
way to set the two coluums up at the top for the complete spread sheet
without setting up each row individually?