Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 02-12-2020, 12:30 PM
DJ0691 DJ0691 is offline Find a specific number pattern in a column Windows 10 Find a specific number pattern in a column Office 2013
Novice
Find a specific number pattern in a column
 
Join Date: Jan 2020
Posts: 18
DJ0691 is on a distinguished road
Default That worked great

Thanks again for the idea - worked like a charm. Here is what I did:
1) Created the helper column K and populated with =E3&E4&E5&E6 on each row. Column E has the individual numbers. The creates one larger number in that cell in column K.
2) Made an input area in cells M2 thru P2
3) In cell Q2, entered the formula:

=IF(P2="","",HYPERLINK("#'File'!E"&(MATCH((M2&N2&O 2&P2),K:K,0)),"Find Pattern"))

4) This creates a hyperlink for user that brings them right to the pattern they are looking for - and only displays when numbers are entered in the input area.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula to check combinations of values in one column to find match from another column kong1802 Excel 1 06-15-2018 05:26 AM
Find and select all string of simlar pattern anon123 Word 4 04-20-2016 11:41 PM
Extract data based on pattern with respect to specific column PRA007 Excel Programming 14 12-04-2015 04:32 AM
Want a quotient using a constant to show up in column c each time a number is added to column b fibbermcghee Excel 2 12-09-2014 05:48 PM
Find & Replace: Wildcards (except this pattern) tinfanide Word 6 01-26-2014 06:39 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:59 AM.


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