thomas.szwed
03-06-2008, 09:12 AM
Please look at the attached spreadsheet.
Here i have a demo of an extract i have taken from SAP. This demo is shortened significantly from 40,000 records to 13. My problem is that I have two records for some employees. They are different as column contains Master in one row and not in the next. If there are two of the same employee records the row i want is ALWAYS the second (the one that contains a value in column B).
Could someone help me with some code that deletes employee records that contain a blank cell in column B ONLY if there are two of the employees records???
Thanks for any help
Here i have a demo of an extract i have taken from SAP. This demo is shortened significantly from 40,000 records to 13. My problem is that I have two records for some employees. They are different as column contains Master in one row and not in the next. If there are two of the same employee records the row i want is ALWAYS the second (the one that contains a value in column B).
Could someone help me with some code that deletes employee records that contain a blank cell in column B ONLY if there are two of the employees records???
Thanks for any help