NewDeal Hot Tip 1006
NewCalcSolution: For example, if you need to count the number of occurrences of the value 5 in each row of the range A1:D10.
The result is... the cell i1 contains the number of occurrences of the value 5 in the range a1:d1, and cell i2 contains the number of occurrences in the range a2:d2, and cell i3 the number of occurrences in the range a3:d3, and so on.
Solution: There's no automatic way to do this in NewCalc. You could create a spreadsheet with a row of the formula:
=a1 =a2 =a3 =a4 etc.and a column of the formula
=a1 =b1 =c1 =d1 etc.then save the spreadsheet as a template.
When you need to change the orientation of a row or column, copy and paste the appropriate set of formulas from the template into the current spreadsheet.
If you need to eliminate the source cells and save only the re-oriented ones, then copy the row or column that you want to save and paste it into Text File Editor. In TFE, use Find and Replace to make the data into a CSV file (replace tabs with commas if it's a row, don't do anything if it's a column). Then import the CSV file into a new spreadsheet and copy and paste the data from there back into the spreadsheet you are working on.
Last Modified 28 Feb 1999