Hi, I download an excel file from a vendor everyday and I need to automatically remove some rows that contains X data, for example rows containing abc, abc1 in column A. Please note the excel name vary. Any ideas? Thank you.
Hi, I download an excel file from a vendor everyday and I need to automatically remove some rows that contains X data, for example rows containing abc, abc1 in column A. Please note the excel name vary. Any ideas? Thank you.
Last edited by dandi10; 09-13-2019 at 08:38 AM.
Hi !
An idea : just use a filter then delete …
Thanks but I need something automatic, I don't want to filter everytime, also, I need to start typing for many filters, as for now I need to remove around 10 rows...
A sample before & after sample sheets based on actuals would be a useful guide rather than us speculating what you are on about.
torachan.
Good idea, I have uploaded 2 files. The file "FIND" is what I need to look into to the another file, once found, remove these rows.
Any help please?
Perhaps after so long a time without a response, you may settle for a formula based solution.
Assuming that you want to keep the SKU's from Sheet1 that are not included in the list on Sheet2 (formerly the Find file), formulas are used to produce the table on Sheet3 as follows.
1. A helper column (G) is added to sheet one and populated using: =ISNUMBER(MATCH(A2,Sheet2!A$2:A$10,0))
Note that the helper column may be moved and/or hidden for aesthetic purposes.
2. The formula that is used to produce the table on Sheet3 is: =IFERROR(INDEX(Sheet1!A$2:A$25,AGGREGATE(15,6,(ROW($A$2:$A$25)-ROW($A$1))/(Sheet1!$G$2:$G$25=FALSE),ROWS($A$1:$A1))),"")
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
Thank you very much!
You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks