8 дек. 2023 г. · I am trying to filter using the below formula: =average( filter('CSV-Export'!K:K,'CSV-Export'!B:B = A17) ) /60 This works for exact text matches, but if I have

11 июн. 2020 г. · In this sample sheet I have FILTER returning from the table rows which match the partial text entered into the orange column.

2 июн. 2020 г. · A simple CTRL+F has been the method up until this point, but there can sometimes be hundreds of results spread all throughout the sheet.

26 мар. 2024 г. · I need to do partial text matching on a cell in one column, and then if it matches, show data from a different column.

27 нояб. 2020 г. · I'm looking to match the item in Desired!A5:A with the paired values in the Source tab where the values only return with "RIC-xxx".

30 июл. 2022 г. · I have an exported sheet of websites and associated data and I'm trying to highlight a list of sites based on a series of filter words/phrases.

12 янв. 2022 г. · I'm having issues when using Index Match for multiple criteria. I seem to encounter issues such as "Function INDEX parameter is out of range".

14 авг. 2024 г. · I am trying to filter Keywords to Positive and Negative by segregating individual words as Positive and Negative, I want only the whole words to be considered ...

27 авг. 2022 г. · It filters your columns to just the one that matches, using REGEXMATCH, your text in G6. FILTER is an array function, so it can do the ...

21 янв. 2020 г. · Hi I am using a "FILTER" formula to pull data from one sheet to another if column T contains "Max" anywhere.