Analyzing Numbers

K

Karen Smith

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?
 
D

Dave F

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
 
Top