copy cell from above with opposite sign
Select the column.
F5SpecialBlanksOK
Type an = sign in the active cell then point(left-click)in cell above and type
*-1 then hit CTRL + ENTER
You can copy those formula cells later as values.
Gord Dibben MS Excel MVP
On Wed, 20 Sep 2006 14:09:01 -0700, andresg1975
wrote:
i have a column containing numbers, every other row there is an empty row, i
would like to copy the cell from above with the opposite sign to that empty
row, how can i do that with a formula or macro. So that i don't have to do
that one by one. Thanks a lot.
|