> 4. At this point you can simply count the number of different mults or
> you can write a formula which will put a 1 in a cell on each line where
> there's a new mult and a blank otherwise. Then you write a formula to
> add up all the 1s.
>
or....
Don't write a formula, but simply highlight the column containing the cells
with the "1's". You will see the sum presented down in the status bar at
the bottom of the Excel window. If it doesn't say "Sum=nn", right-click on
the status bar and select "Sum"
or....
Don't write a formula, don't put "1's" in a column to indicate mults, but
simply highlight the column (less any header) containing the mults. You
will see something presented down in the status bar. If it doesn't say
"Count=nn", right-click on the status bar and select "Count". You should
see the number of fields counted displayed.
73,
dale, kg5u
_______________________________________________
Trlog mailing list
Trlog@contesting.com
http://lists.contesting.com/mailman/listinfo/trlog
|