Ex: =A1+A2 next cell down A3+A4 next cell down A5+A6, not A1+A2, A2+A3, A3+A4. I am trying to net cells, some are exact duplicates, some are not
Need your help because I am not sure of the correct formula to use (if ever there is one!) in Excel 2010. Say in column A, I have my figures (A1 to A1000). Suppose in column B I need to get the ...
How do I copy and paste only the results of a calculation without copying the formula behind it? I'm learning to use Open Office Calc. I remember other spreadsheets that had a values function, or ...
Here is what I have in my worksheet: A1=2 B1=3 C1=A1+B1 I want the actual cell to show 5 but when I copy C1 I want the formula in the cell to show =2+3, not =A1+B1 or 5 is there a way to do ...
If I make an equation: ' on cell A2 =A1 Is there a way to make A2 have the exact same formatting as A1 and not just the value? EDIT: i.e. I want a FORMULA that copies both the value and the ...
If you write a formula like: =sumproduct((something=$A1)*(somethin=$B1)) Giving a result of 8. Usually the references and results change as you drag it down into other cells. Well,the references ...