software

I am working in Excel 2003. I have two columns of numbers (ID numbers for
employees of 6 digits each). If a number appears in column A (there are no
duplicates of this number in column A), the number must NOT appear in column
B. Is there any way, besides VBA, to check if a number appearing in column
A is also listed in Column B?

Thanks,

Ricki
Hey *smiles* Hope this helps...
office.microsoft.com/en-us/as...289521033.aspx Good luck!

quot;Ricki Milesquot; wrote:

gt; I am working in Excel 2003. I have two columns of numbers (ID numbers for
gt; employees of 6 digits each). If a number appears in column A (there are no
gt; duplicates of this number in column A), the number must NOT appear in column
gt; B. Is there any way, besides VBA, to check if a number appearing in column
gt; A is also listed in Column B?
gt;
gt; Thanks,
gt;
gt; Ricki
gt;
gt;
gt;

Hi Ricki,

Put this formula in C1 and fill down. The cells will be blank or have a
number in them. These are duplicates.

=IF(COUNTIF($A$1:$A$5,B1)gt;0,B1,quot;quot;)

HTH
Regards,
Howard

quot;Ricki Milesquot; gt; wrote in message
...
gt;I am working in Excel 2003. I have two columns of numbers (ID numbers for
gt; employees of 6 digits each). If a number appears in column A (there are
gt; no
gt; duplicates of this number in column A), the number must NOT appear in
gt; column
gt; B. Is there any way, besides VBA, to check if a number appearing in
gt; column
gt; A is also listed in Column B?
gt;
gt; Thanks,
gt;
gt; Ricki
gt;
gt;
Thanks for the information.quot;Nariannaquot; .(DO_NOT_SPAM).gt; wrote in message
...
gt; Hey *smiles* Hope this helps...
gt; office.microsoft.com/en-us/as...289521033.aspx Good
luck!
gt;
gt; quot;Ricki Milesquot; wrote:
gt;
gt; gt; I am working in Excel 2003. I have two columns of numbers (ID numbers
for
gt; gt; employees of 6 digits each). If a number appears in column A (there are
no
gt; gt; duplicates of this number in column A), the number must NOT appear in
column
gt; gt; B. Is there any way, besides VBA, to check if a number appearing in
column
gt; gt; A is also listed in Column B?
gt; gt;
gt; gt; Thanks,
gt; gt;
gt; gt; Ricki
gt; gt;
gt; gt;
gt; gt;
It worked perfectly. Thanks again.

quot;L. Howard Kittlequot; gt; wrote in message
. ..
gt; Hi Ricki,
gt;
gt; Put this formula in C1 and fill down. The cells will be blank or have a
gt; number in them. These are duplicates.
gt;
gt; =IF(COUNTIF($A$1:$A$5,B1)gt;0,B1,quot;quot;)
gt;
gt; HTH
gt; Regards,
gt; Howard
gt;
gt; quot;Ricki Milesquot; gt; wrote in message
gt; ...
gt; gt;I am working in Excel 2003. I have two columns of numbers (ID numbers
for
gt; gt; employees of 6 digits each). If a number appears in column A (there are
gt; gt; no
gt; gt; duplicates of this number in column A), the number must NOT appear in
gt; gt; column
gt; gt; B. Is there any way, besides VBA, to check if a number appearing in
gt; gt; column
gt; gt; A is also listed in Column B?
gt; gt;
gt; gt; Thanks,
gt; gt;
gt; gt; Ricki
gt; gt;
gt; gt;
gt;
gt;