Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SEeing if a number in one column is in another column
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
SEeing if a number in one column is in another column
Hey *smiles* Hope this helps...
http://office.microsoft.com/en-us/as...289521033.aspx Good luck! "Ricki Miles" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
SEeing if a number in one column is in another column
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)0,B1,"") HTH Regards, Howard "Ricki Miles" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
SEeing if a number in one column is in another column
Thanks for the information.
"Narianna" .(DO_NOT_SPAM). wrote in message ... Hey *smiles* Hope this helps... http://office.microsoft.com/en-us/as...289521033.aspx Good luck! "Ricki Miles" wrote: 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
SEeing if a number in one column is in another column
It worked perfectly. Thanks again.
"L. Howard Kittle" wrote in message . .. 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)0,B1,"") HTH Regards, Howard "Ricki Miles" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Program Column B to record numerical range based on number in colm | Excel Discussion (Misc queries) | |||
Running total w/2 columns - Excel | Excel Worksheet Functions | |||
look up number in column | Excel Worksheet Functions | |||
How do I sort a column a unique number? | Excel Worksheet Functions |