NewDeal Hot Tip 1006

[Hot Tips for...] NewCalc

NewCalc Frequencies, Headers, and Rotate Cells

Frequency Counts

Problem: I want to use NewCalc to do frequency counts on some data, that is, to count the number of times each value appears in a range of cells.

Solution: 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.


Rows to Columns

Problem: How to copy a number of cells in a rows to a defined number of cells in a column and visa versa.

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.


How to print headers

In one cell, enter the text you wish to use as a header and, if the text extends beyond the width of the cell, select all the cells where the header text appears. Then click the Cell menu, Headers/Footers, Set Header. After setting this block as a header, it will print. The header text does not have to be placed above the spreadsheet. It can be placed anywhere, as long as all the cells that are affected by the text are selected and set as a header.
Return to Index

Last Modified 28 Feb 1999