markdaniels
New Member
- Joined
- Feb 22, 2019
- Messages
- 1
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
Also posted
https://chandoo.org/forum/threads/search-with-offset-indirect-substitute-functions.41009/
http://www.msofficeforums.com/excel...indirect-substitute-functions.html#post138823
=OFFSET(INDIRECT(SUBSTITUTE($F16," ","")),0,0,COUNTA(INDIRECT(SUBSTITUTE($F16," ","")&"Col")),1)
All helpful ideas welcome
Also posted
https://chandoo.org/forum/threads/search-with-offset-indirect-substitute-functions.41009/
http://www.msofficeforums.com/excel...indirect-substitute-functions.html#post138823
Last edited by a moderator:
