copy cell from above with opposite sign
Another very similar way:
Select the range to fix
edit|goto|special|check blanks
type the equal sign
then hit the up arrow
then type *-1
and hit ctrl-enter to fill the blank cells with your formula.
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.
--
Dave Peterson
|