|
|
#1
02-22-2019, 02:44 AM
|
|||
|
|||
Search with OFFSET INDIRECT SUBSTITUTE functions
Is there are a way to combine the following calculation so it is searchable? By that I mean the cell that uses this validation to narrow down when to start to type?
=OFFSET(INDIRECT(SUBSTITUTE($F16," ","")),0,0,COUNTA(INDIRECT(SUBSTITUTE($F16," ","")&"Col")),1) All helpful ideas welcome 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Can I substitute Vlookup with Index | paxon | Excel | 4 | 03-10-2016 07:03 AM |
 Substitute for Content Controls in Word 97 - 2003 Document
|
taryn | Word | 4 | 02-13-2015 01:30 PM |
|
Help with LEN and Substitute function
|
Natalee | Excel | 5 | 11-08-2014 07:56 AM |
|
Set offset properties of a picture
|
charm | PowerPoint | 1 | 11-01-2014 05:41 AM |
|
Find & Replace: substitute red-coloured words with underscores
|
tinfanide | Word | 2 | 10-06-2012 11:04 PM |
Windows 7 32bit 
Office 2010 32bit
Threaded Mode