Jan 14, 2025 · Filter function ignore blank rows Hello. I'm trying to use the FILTER function to transfer data from B5:E15 to another range of cells using the FILTER formula =FILTER …

May 19, 2023 · Hi all, I have successfully used the INDIRECT function to create dropdown lists for a single column, such as here in cell C2, where I have a simple dropdown of four shapes. That …

Jan 5, 2024 · Filter function with multiple tables/arrays I have a sheet with data in it (customers contacts in this example, where columns contain name, surname, company and email) and …

Jun 27, 2024 · Filter function not working Hello, I am trying to filter data from one sheet to another in Excel. I want the range for the formula to include whole columns as I want it to be a living …

Jun 29, 2023 · In Excel, you cannot directly use the FILTER function as an input to the RANK function. The RANK function requires a range of values as its first argument, and the FILTER …

Aug 10, 2023 · You can't combine countif with filter, as countif deals with ranges but not arrays. You can, however, use a combination of Count and If to achieve the same result:

Mar 18, 2025 · FILTER Function Help; Filtering on a column with a Formula I'm attempting to use the FILTER function on a table in a different sheet. I've confirmed that the FILTER function …

Jun 22, 2025 · Excel FILTER function not working with some formulas Hey all, Very weird issue: The FILTER function doesn't return anything when the target cell contains certain (but not all) …

Sep 13, 2023 · I have Microsoft excel 365 in that filter function is available and i create a follow up sheet linked with database sheet where in database user will store data from the form.

Mar 8, 2024 · Karinanzr FILTER looks at the values of cells, not at their formulas, so it should work, in principle. Could you attach a small sample workbook demonstrating the problem …