Dear reader,
I've a question regarding excel.
In my company we use an ERP package, which contains the number of 'tools' we have in our company.
The system is a mess and counts over 1000+ article numbers.
Now, we have counted the real stock of tools. and these are about 500.
In excel we have now four columns.
1 column 2. column 3. column 4. column
ARTICLE NUMBER STOCK IN SYSTEM ARTICLE NUMBER REAL STOCK
G0514954 0,00 G3505030 8
G0514955 0,00 G4005004 10
G0514956 0,00 G4005006 20
G0514957 0,00 G4005010 10
G0514958 0,00 G4005016 5
G0514959 0,00 G4005017 9
is there a way/formula/script that generates a match between the two article numbers and places the system value and the real value next to each other?
I hope someone can help me
Kind regards,
Erik de Meijer
Netherlands
Configuration: Windows XP Firefox 3.5.2
Count one of each in a column excel Countif each entry in a column excel Drop menu from two columns excel Excel comparing data in two columns Excel find value column put link Excel formulas duplicate data columns Excel how to pick value based on two columns Excel list into 1 column Excel vb filtering on multiple columns Excel vba match two columns of names Finding if cell data exists in column excel Finding part if cell data exists in column excel How to match emails in columns, excel How to sort match number in excel Match function in excel vba 2007 Match two columns in excel Ms-excel formulas to compare the columns and give the numbers which are not matched Vba excel compare 2 columns find matches