The new forums will be named Coin Return (based on the most recent vote)! You can check on the status and timeline of the transition to the new forums here.
The Guiding Principles and New Rules document is now in effect.
Any Excel wizards who can help me out here?
Visti
Registered User regular
Registered User regular
So, this one is a melon-scratcher, I'm sure. At least, it is for me. Consider the following; I have a text file containing a ton of lines, like this:
There's nothing else in this text document. I have an excel sheet (or two, acutally) that have a ton of entries, some of which match these unique identifiers in a column cell, like this:
and so on. Way too many entries for me to manually search each line from the text document and delete the corresponding entry in the sheet.
Is there any way to automate this? Basically using the file to find multiple rows, so that I can delete them all if any of the entries contain any of the lines in the text document.
I'm looking at potentially hours and hours of manual search and delete here, if not.
2103-01 2865-20 1531-12 1313-09 2865-19 0276-01 6745-13 8208-03 1900-12 8198-04 3177-28 0028-14 1216-16
There's nothing else in this text document. I have an excel sheet (or two, acutally) that have a ton of entries, some of which match these unique identifiers in a column cell, like this:
Bay City Rollers | Bye Bye Baby (Long Version) | 1975 bc | Re-Record | 2103-01 Billy J Kramer | Dizzy | 1984 bc | Re-Record | 0072-03
and so on. Way too many entries for me to manually search each line from the text document and delete the corresponding entry in the sheet.
Is there any way to automate this? Basically using the file to find multiple rows, so that I can delete them all if any of the entries contain any of the lines in the text document.
I'm looking at potentially hours and hours of manual search and delete here, if not.
[SIGPIC][/SIGPIC]
0
Posts
Put them in a single file (2 sheets) and do this
1st sheet - numbers
2nd sheet - details
empty column to the right of the details in the 2nd sheet - =Vlookup(KeyFieldIn2ndSheet, Sheet1!A:A, 1, FALSE) then fill the rest of the detail sheet down
Then filter on items that aren't #N/A in that column and delete those rows. You have now deleted all matches.