ANSWERS TO YOUR QUESTIONS ABOUT LOTUS PRODUCTS
This month we are asking you to submit one formula (only one) that tests a range of values and returns a number representing the number of values in the range that are greater than zero. For example, in the following figure, cell B1 contains a formula that returns the number of values in range A1..A5 that are greater than zero:
The first 25 people who submit entries that the LOTUS judges consider the best answer will receive a Lotus flight bag. Please send your formula on a nonreturnable disk along with a printout of your contest entry, and please document your entry with appropriate comments. All entries must be postmarked before midnight, February 28, 1987. Winners will be announced in the May 1987 issue. Send your answers to February Contest, LOTUS Magazine, P.O. Box 9123, Cambridge, MA 02139-9123.
If you have a contest idea that you would like us to print, send it to Contest Idea, LOTUS Magazine, P.O. Box 9123, Cambridge, MA 02139-9123. We'll send you $25 for each idea we use.
RECALCULATING A RANGE
Q. As my worksheets get larger, I use the Worksheet Global Recalculation Manual command, which allows me to recalculate the worksheet by pressing the CALC key. Sometimes I enter new data in only a few cells that affect only a few other cells. Is there any way of recalculating just a range, instead of the whole worksheet? Jerome E. Tuttle U.S. Insurance Group Basking Ridge, N.J.
A. You can recalculate a range by copying the range onto itself. For example, to recalculate range C42..D60, select/Copy (MENU Copy in Symphony), specify C42..D60 as the From range, then specify the same range, C42..D60, as the To range. Only that range will recalculate.
If you're using Symphony or 1-2-3 Release 2, you can use [RECALC location] or [RECALCCOL location] in a macro to recalculate a range.
ROTATING A DATA MATRIX
Q. Do you know of a way to rotate a data …