Tuesday, April 14, 2009

Inpsirational Sayings On Keepsakes

sort data = COUNTA

(Click image to enlarge)

This is the case of a form where need to sort the list by COURT (column C) and then SECRETARIAT (column D), but in turn need to have the CAUSES (column E), in alphabetical order in each trial.
To sort data in Excel always have to select (paint) all the data.
A mistake at this stage can yield disastrous results. Paint
then RETURN ALL, including the column headings.
Now, right click and choose Sort and then custom order.
1) Sort by COURT
2) Then by SECR
3) Then by CAUSE

and so is

Radio Shack Md-1700 Midi Software



= COUNTA function has no empty cells in a range

To serve:

In this form the user enters new rows (and data) every day. As a lot of data and every now and need to go to the end of the return, = COUNTA returns the number of the last row loaded and avoids having to scroll down to.

(click to enlarge)

Click on the image, the formula = COUNTA (A: A) indicates that the last figure is in line 536.

To go to cell F5 press.

Wednesday, April 1, 2009

Yeast Infection Caused By Being Fingered




is a form where the amounts of the cells D26 and E26 are updated as they enter expenses and payments. The ending balances for debtors to creditors pass and vice versa as they changed the aggregate amounts. The company requires that when the balance of negative figures in D26 and E26 appear automatically in RED and when the balance is favorable, the figure displayed on BLACK.

The problem is solved using Conditional Formatting.


Condition 1: If the cell value is less than 0, bold red
Condition 2: If the cell value is greater than 0, bold black