Microsoft Office Tutorials and References

In Depth Information

**Syntax:**

33. Add the heading All Match?

All Match? in column G.

44. Add a formula in column G to compare whether each of the cells in the

original data set matches the cells in the returned data set. Add the

formula =AND(A6=I6,B6=J6,C6=K6,D6=L6,E6=M6) in cell G6 to compare

all five cells in the data set.

55. Copy the formula down column G from cell G6 to match the number of

rows in the data set.

66. In cell G2, enter an AND formula to test whether all the formulas in

column G are TRUE. Even though this range contains more than 255

cells, it is still valid to use it as one of the expressions in the AND

function. The formula in G2 is =AND(G6:G999). This is a quick way to

find out whether every row is identical without having to scroll

through pages of data, looking for a single FALSE result. If cell G2

returns TRUE, you know that the original and returned worksheets are

identical. If cell G2 returns FALSE, you know that one or more of the

rows were changed.

77. Select G6:G999. From the Home tab, select Find & Select, Find. The Find

and Replace dialog appears.

88. In the Find and Replace dialog, type FALSE

FALSE into the Find What box.

You must click the Options button and change the Look In drop-down

from Formulas to Values to find formulas that result in a value of

FALSE.

Figure 12.3.

Figure 12.3.
AND

AND can test whether a large range of logical tests are all

can test whether a large range of logical tests are all

TRUE

TRUE..