Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-29-2018, 11:11 AM
cover cover is offline Searching multiple numbers at once Windows 7 64bit Searching multiple numbers at once Office 2007
Novice
Searching multiple numbers at once
 
Join Date: Jan 2012
Posts: 4
cover is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 04-29-2018, 11:04 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Searching multiple numbers at once Windows 7 64bit Searching multiple numbers at once Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,779
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

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
Reply With Quote
  #3  
Old 04-30-2018, 07:37 PM
BobBridges's Avatar
BobBridges BobBridges is offline Searching multiple numbers at once Windows 7 64bit Searching multiple numbers at once Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

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.)
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Searching multiple numbers at once 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 numbers at once Searching Multiple PowerPoint & Word Files BobbyAre PowerPoint 14 08-12-2012 06:52 AM
Searching multiple numbers at once searching for text in multiple excel files roytom Excel 2 07-30-2012 01:57 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:32 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft