Thread: Search with OFFSET INDIRECT SUBSTITUTE functions
View Single Post
 
Old 02-22-2019, 02:44 AM
MarkD MarkD is offline Windows 7 32bit Office 2010 32bit
Novice
  
Join Date: Jan 2017
Posts: 2
MarkD is on a distinguished road
Default 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
Reply With Quote