#1
|
|||
|
|||
Searching multiple numbers at once
I have a spreadsheet with 10,000 rows of data with each row beginning with a unique number that represents that unique row. I have 90 numbers that I would like to search for all at once if possible, and then remove those rows all at once (this as opposed to the tedious task of removing the rows one at a time, searching one number at a time).
Is it possible to search many numbers at once in Excel? TIA |
#2
|
||||
|
||||
I don't know if it works for 90 numbers but the advanced filter could help ( you'll have to enter the numbers, though :-) )
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
||||
|
||||
This looks like a great place for a VBA program. But then, I code at the drop of a hat; if you don't know how and/or don't want to, off-hand I think Pecoflyer's answer is best.
If you want to think about making it a quick program, though, I'd start by guessing that a) you need to do this not just once but occasionally, and b) the 90-or-whatever row numbers you want to delete are contained in some list somewhere—that is, that the program could find those numbers in some other file or worksheet and use them to figure out which rows to highlight. The program stops once they're highlighted, and lets you look them over before deleting them in one or two manual keystrokes. (I don't like to let a new program delete data without giving me a chance to look it over first, at least not until I've done it several times and have learned to trust the routine.) |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Wildcards: searching for multiple words / expressions close to each other | ballpoint | Word VBA | 7 | 11-09-2017 03:30 PM |
Excel Index and Match function with multiple criteria not searching the next record | mushtaqkadar | Excel | 3 | 06-17-2017 12:20 AM |
Single value on multiple numbers in row into column | T1000 | Excel | 0 | 02-14-2017 11:54 AM |
Searching Multiple PowerPoint & Word Files | BobbyAre | PowerPoint | 14 | 08-12-2012 06:52 AM |
searching for text in multiple excel files | roytom | Excel | 2 | 07-30-2012 01:57 PM |