For the column you want to analyze, do a formula like
=COUNTIF([range],"0600"). If COUNTIF finds 0600 in the range you specify it
will return a number, otherwise it will return nothing.

You could expand this into something like
=IF(COUNTIF([range],"0600")0,"0600 occurs in this list","0600 does not
appear in this list")

Dave
--
Brevity is the soul of wit.


"Karen Smith" wrote:

Is there a way to analize a column to see what is missing? ie i have a
column with a bunch of minor account numbers in it (0600, 0678, etc many
#'s), I want to analize another tab with a column of minor account numbers to
see what I'm missing from the other tab. Is there a way to do this easily?