Excel Data Filtering and Transfer -- 2
Budget: $30 – $250 USD
I need assistance with a specific task in Microsoft Excel.
Here's what I need:
- Search column in sheet1 for positive numbers.
- If a positive number is found, check if the corresponding date in column E is within the last 180 days.
- If both conditions are met, extract the project reference number and the positive number from column M.
- Transfer this data to Sheet2. In Sheet2, column B already has the project reference numbers, so you might need to use a V-lookup to place the value from column M into column I.
Additionally, I have specific error-checking and validation rules that need to be enforced before data is transferred:
- Only positive numbers should be considered.
- Duplicate entries should not be transferred.
- All dates must be in the correct format.
Ideal skills for this job include proficiency in Microsoft Excel, particularly with functions like V-lookup, as well as attention to detail for error-checking and data validation.
Here's what I need:
- Search column in sheet1 for positive numbers.
- If a positive number is found, check if the corresponding date in column E is within the last 180 days.
- If both conditions are met, extract the project reference number and the positive number from column M.
- Transfer this data to Sheet2. In Sheet2, column B already has the project reference numbers, so you might need to use a V-lookup to place the value from column M into column I.
Additionally, I have specific error-checking and validation rules that need to be enforced before data is transferred:
- Only positive numbers should be considered.
- Duplicate entries should not be transferred.
- All dates must be in the correct format.
Ideal skills for this job include proficiency in Microsoft Excel, particularly with functions like V-lookup, as well as attention to detail for error-checking and data validation.