Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
H ave two columns of Serial #s like (A26B3 or 125R6F) I need to I compare the
two columns to see where the differences are. I think I need to say IF A1 is contained in column B then copy the contents of A1 to C1. IF A1 is not in column B copy A1 to D1.---Repeat, repeat repeat and IF B1is not in column A the place B1 in E1. ---repeat, repeat repeat. I need to find out where both scanner (human error on input) errors are as well as Inventory errors (human keboard input) are, be cause Im driving myself nuts trying to find out which serial#s are in which column and which are not, can any body think of how i could pose the argument (even if its not excel, but say access) so that I can do this Keith |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I think I'd just insert two columns--a new column B and a new column D.
Then in B1: =if(isnumber(match(a1,c:c,0)),"In Column C","Missing from C") and drag down Then in D1: =if(isnumber(match(c1,a:a,0)),"In Column A","Missing from A") and drag down Then I'd insert a new header row in row 1. Select A:D Data|filter|autofilter Then I could filter to show the missing and copy those visible cells whereever I wanted. (Yeah, I'd have to filter twice to get both columns.) Keith wrote: H ave two columns of Serial #s like (A26B3 or 125R6F) I need to I compare the two columns to see where the differences are. I think I need to say IF A1 is contained in column B then copy the contents of A1 to C1. IF A1 is not in column B copy A1 to D1.---Repeat, repeat repeat and IF B1is not in column A the place B1 in E1. ---repeat, repeat repeat. I need to find out where both scanner (human error on input) errors are as well as Inventory errors (human keboard input) are, be cause Im driving myself nuts trying to find out which serial#s are in which column and which are not, can any body think of how i could pose the argument (even if its not excel, but say access) so that I can do this Keith -- Dave Peterson |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Thank you sooooo much, You have just saved me hours of time! It works
magnificantly! Keith "Dave Peterson" wrote: I think I'd just insert two columns--a new column B and a new column D. Then in B1: =if(isnumber(match(a1,c:c,0)),"In Column C","Missing from C") and drag down Then in D1: =if(isnumber(match(c1,a:a,0)),"In Column A","Missing from A") and drag down Then I'd insert a new header row in row 1. Select A:D Data|filter|autofilter Then I could filter to show the missing and copy those visible cells whereever I wanted. (Yeah, I'd have to filter twice to get both columns.) e Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Automate Import/Export | Excel Discussion (Misc queries) | |||
Automate simple calculation/formula | Excel Worksheet Functions | |||
automate creation of sheets in excel | Excel Worksheet Functions | |||
Automate Excel to powerpoint - Graphs along with Datasheet (not workbook) | Charts and Charting in Excel | |||
How can I automate a 16 man wrestling bracket in Excell. | Excel Worksheet Functions |