![]() |
#4
|
|||
|
|||
![]()
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. |
|
![]() |
||||
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 |