filter function

0 I have seen many posts for using the filter function for multiple criteria and the solutions works great if both cells that you are looking for a match in only has 1 line of data. I have a spreadsheet where one of the columns in which you are looking for a match has cells that have multiple...

I am having trouble cross referencing and filtering 2 tables for matching numbers. One table has a list of all employees and whether they have passed training. Table1[Number],Table1[Pass] I have another table with employee numbers that are on shift today. Table2[Number] I want to filter my...

I have a lengthy process that ends in a dynamic, single cell spill array (shown below). This array currently reports all records from a data table. However, I would like to exclude rows where certain cells are blank. I'm feeling like =FILTER() is the right tool, I'm just not able to configure it...

Hello, I have a large set of data, I am trying to filter it, but only have 25 values. I am trying to use the Large function, but it is only bringing me 1 value. Any thoughts? =LARGE(SORT(UNIQUE(FILTER(CHOOSE({1,2},VimsDay[Document Id],VimsDay[Days to Due]),(VimsDay[Extraction...

Hello, I'm not having any luck using wildcards to return values from a table of data based on a list in a Named Range. I'm using the following to return a list of books that are part of a given Series. However, due to multiple values in the Series column, I need to be able to use wildcards...

Hi, See attached a sample job scheduling dataset. I need to lookup the bay # and return the job # which is simple enough with an xlookup. However, there will be multiple jobs with the same bay # and I need a way to be able to only pull the job number that starts after a certain date. I would...

I have 2 dynamic arrays; one for the first column of data (vertical) and a second for a header row (horizontal) which together make up a grid view. I need a formula that will spill dynamically when there are changes to either the horizontal or vertical ranges. I want to use the combination of...

I can't seem to figure out how to do this. (I use Excel 365.) I have a master schedule sheet (below) of employees, their shifts, breaks and what fraction of the hour they work on what days. I also have one sheet for every date of the month. That means 28-31 different dated sheets in the monthly...

I am trying to use a filter function through VBA, in a change event in a specific column. I am using the activecell address in the filter formula, but everytime I hit enter, I get error 50290. what I am actually trying to do is a dynamic searchable dropdown list, but this error is preventing me...

I posted an item regarding Mr.E's Excel Formula To Extract Country From Phone Number - 2370 which I loved here today. I used a 365 formula to lookup Country Codes like this: AB1+447594361587United Kingdom2+41769482539Switzerland3+35056369249GibraltarB1:B3B1=LET(Ph,SUBSTITUTE(A1,"+","")...

Hello excel experts, I have annoying (crappy) data, and I am trying to grab all names from a column that meets a couple criteria. In that column are subtotal rows with a count of names and a TOTAL heading, and category headings like: - 2020 Sold Properties - 2020 Completed Refi - 2021...

I would like to return multiple non consecutive columns with a filter function in vba, using formula2, but I don't know how. I need to use a fixed range from A6:P65536. Any help will be greatly appreciated. Thanks in advance.

I would like to use the filter function if it is possible to have a table filtered by a column of data that is in a separate table I have two tables: Table 1 Case Identifications numbers, + loads of other associated data in many columns Table 2 [Really just a column] Case Identifications...

Hi I have a FILTER array which lists multiple results from another Table (Column J). These have associated results that I would like to dynamically expand to list in a separate column (K). Is this possible? Cheers

Hi. I have an Excel file with sales data, such as sales agent, location as city, product, quantity, customer, amount etc. With FILTER function I fetch to a new sheet the sales amount for all sales agents and certain cities across Europe. Is it possible to indicate within the formula that the...

Hi everyone, I'm using the Filter function and it's returning several values. I only need one of those value. Let's say the first one. Is there a way to do that? Thank you

Hi, I have managed to get the perfect formula to filter the results by specific number of criteria (dropdown lists). However, I need to add another condition, if any of the criteria is "ALL" then count all population and filter the results accordingly. I'm attaching a sample file to show my...

Hello Excel Experts, Need help with this situation as can not find a way on how to do it. I have 2 sheets in a workbook. Sheet 1 has a data that has a hyperlinks to different sheets in the workbook. On sheet 2, I have created a filter function to extract the data on sheet 1. My issue is the...