Forum Discussion
Solved
Combining FILTER, MID, and FIND functions
We use Excel to manage logs from many agricultural trials. There is a central 'live' table where live data for all trials gets sent to, but ultimately only the relevant data needs to be sent to each ...
How about
=FILTER(OnlineSprayBookAllData[[Date]:[Photo or Video]], ISNUMBER(SEARCH(Table5[@SITE1], OnlineSprayBookAllData[Trial])), "Please check GOA code is entered in SITE_DATA")
Does it work if you use SEARCH instead of FIND? FIND does not return an array of values, but SEARCH does.
Thanks for the feedback, but unfortunately no, I haven't been able to make it work with SEARCH.
How about
=FILTER(OnlineSprayBookAllData[[Date]:[Photo or Video]], ISNUMBER(SEARCH(Table5[@SITE1], OnlineSprayBookAllData[Trial])), "Please check GOA code is entered in SITE_DATA")
- Brilliant! Thanks works really well. Thank you kindly!