EXCEL - Advice for completing a task automatically (not manually)
Budget: $15 – $25 CAD
READ ALL OF THE PROJECT DETAILS
The MAXIMUM pay for this project is $15
We have an Excel Sheet that contains 1603 rows/records.
Out of 1603 rows/records we have to delete 511
rows/records.
We have a list of numbers for the rows that need to be removed from the excel sheet. For example row 2, 6,11,19, 45, 68 etc.
The list of rows numbering is the default excel sheet row numbering at the left most side.
TASK: We are looking for an automatic way in Excel based on which we can delete the required 511 rows at the same time. We are looking for an Automatic method where we add copy and paste the required rows numbering and they will get deleted automatically.
Note: Our Data is not based on Values and Ranges and we know all Formulas that select the Data based on Values and Ranges or Blanks. Our Data is Contacts and we need to delete 511 Contacts out of 1603 and we have to delete those contacts based on the row number pointing to a specific contact.
TASK: We are looking for an automatic way in Excel based on which we can delete the required 511 rows at the same time. We are looking for an Automatic method where we add copy and paste the required rows numbering and they will get deleted automatically.
Note: Our Data is not based on Values and Ranges and we know all Formulas that select the Data based on Values and Ranges or Blanks. Our Data is Contacts and we need to delete 511 Contacts out of 1603 and we have to delete those contacts based on the row number pointing to a specific contact.
IMPORTANT: We do not need any Manual method where we need to select each row manually. We do not want to look at the row number, find it in the sheet and manually select it. We know everything about Manual work.
We are looking for an Automatic way which can select 511 records automatically and can delete those records automatically by feeding/pasting the number of rows one time in the Formula.
The MAXIMUM pay for this project is $15
We have an Excel Sheet that contains 1603 rows/records.
Out of 1603 rows/records we have to delete 511
rows/records.
We have a list of numbers for the rows that need to be removed from the excel sheet. For example row 2, 6,11,19, 45, 68 etc.
The list of rows numbering is the default excel sheet row numbering at the left most side.
TASK: We are looking for an automatic way in Excel based on which we can delete the required 511 rows at the same time. We are looking for an Automatic method where we add copy and paste the required rows numbering and they will get deleted automatically.
Note: Our Data is not based on Values and Ranges and we know all Formulas that select the Data based on Values and Ranges or Blanks. Our Data is Contacts and we need to delete 511 Contacts out of 1603 and we have to delete those contacts based on the row number pointing to a specific contact.
TASK: We are looking for an automatic way in Excel based on which we can delete the required 511 rows at the same time. We are looking for an Automatic method where we add copy and paste the required rows numbering and they will get deleted automatically.
Note: Our Data is not based on Values and Ranges and we know all Formulas that select the Data based on Values and Ranges or Blanks. Our Data is Contacts and we need to delete 511 Contacts out of 1603 and we have to delete those contacts based on the row number pointing to a specific contact.
IMPORTANT: We do not need any Manual method where we need to select each row manually. We do not want to look at the row number, find it in the sheet and manually select it. We know everything about Manual work.
We are looking for an Automatic way which can select 511 records automatically and can delete those records automatically by feeding/pasting the number of rows one time in the Formula.