about as simple as it gets or ?

Date: Tue, 27 Oct 2009 19:04:37 -0700 (PDT)
From: Jella <artsci2 yahoo com>
Subject: about as simple as it gets or ?

To get a set of positive numbers pasted as negative is easy.

Select your array of positive numbers, right click and copy, select
the upper left cell where you wanat the negatives to appear, right
click and select "paste special" and then click on "subtract. viola!



Thanks for this pearl of wisdom. I guess this is the "correct" way to
achieve the right result. Just need to be certain that the destination
cells are empty otherwise confusion reigns.

This also provided a useful pointer to the use of paste special. I
hadn't explored or used it much up to now, but I now see that there is
a lot of power in the paste special with the exercise of a little
thought and planning.

Viola or violins, or voila. Thanks again.


Chris Dunn

[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]