View Single Post
 
Old 02-11-2020, 08:13 AM
DJ0691 DJ0691 is offline Windows 10 Office 2013
Novice
 
Join Date: Jan 2020
Posts: 18
DJ0691 is on a distinguished road
Default Find a specific number pattern in a column

Hi Gurus,

I have a sheet with a long column with several thousand numbers in the rows. I need to search through this entire column and find a specific pattern of contingent numbers if it exists.

Example: column B1:B5678 contains many entries in the rows containing numbers. I'd like to enter something like in cells C1:C3 the numbers 15, 39 and 54. The formula or VBA would look through B1:B5678 and see if numbers 15, 39 and 54 are in contingent cells in this column and if so, tell me where.

I've explored the MATCH, FIND and SEARCH functions but they are typically looking for a single value while I'm looking for 3 values together in contingent cells.

Any ideas? Thanks!!
Reply With Quote