Forum Discussion
Solved
How would I add to this formula so it will incorporate multiple rows not just A5 ...
=SORT(FILTER(A2:A99,ISNUMBER(SEARCH(Report!A5,A2:A99)),"not found")) Thanks in advance for any and all suggestions. 🙏 Don Y
Riny_van_Eekelen , DonYTechGuy
Not sure if you checked this latest tip from Leila https://www.youtube.com/watch?v=waqzwMCYD9I, perhaps it could help
Link to view file if needed ... https://1drv.ms/x/s!AhjBvv1f6Unw6yml1OjuIWCjUAII?e=buDRwZ it's a view-only link.