| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional formatting | Excel Worksheet Functions | |||
| How to generate sets of random numbers without having duplicates | Excel Worksheet Functions | |||
| Why are 1/2 my numbers imported as text and the rest as numbers? | Excel Discussion (Misc queries) | |||
| How do I sort letters before numbers in Excel? | Excel Discussion (Misc queries) | |||
| Sorting when some numbers have a text suffix | Excel Discussion (Misc queries) | |||
Linear Mode
