Microsoft Office Tutorials and References
In Depth Information
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
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