ExcelBanter - Analyzing Numbers

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Analyzing Numbers (https://www.excelbanter.com/excel-discussion-misc-queries/109736-analyzing-numbers.html)

Analyzing Numbers

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?

Analyzing Numbers

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?