Is there a way to search for a single column or any two columns of numbers and place them on a new sheet for review. I would like to be able to look for any-wheres from 2 to 20 of liked numbers. In this example am looking for four 3s so I place four 3s in AC5:AC8 and press the search button. I would also like to catch 15 rows above and below the numbers I am looking for. An example of what it finds is below
Here is a snip of what I am asking for.
example search single digits pic.jpg
example findings pic.jpg
Reply With Quote