filter

Hi, I requrie a formula in sheet 2 cell AW2 through to AW99 to search using the data shown in Sheet 2 Cell A2 (to A99 as it will repeat on each row) This will then search for the same data in Sheet 1 Cell C2 to C99, and return the first occurance of the value shown within Column N that matches...

I want to get a summary of the unique value under a condition. Like in the below table- 1. For article BD-01, the Sorted (A-Z) unique area code is 11, 12, 15. 2. Then for these Unique codes, there are some product codes. 3. Now I want to Join all Area code and their Product codes with separator...

Hi, I have table queries which are appended into one query. see below I have a sheet which some fields are taken from above (some not shown here) see below Columns 1 - 3 are Pivot Table fields Merged cells in merged column 4 is formula cell - The result of the formula will show text of the...

Hi All, I am building a data set from a download of data from our Reporting Tool. To ensure the data reconciles: - For 2023 Plan I need to take All Country Data - For Actual reporting, I need to exclude one of these My Question is - How can I build a Pivot Report based on the whole data, with...

Hello, This is a small part of my table. As seen, there are three main rows which need to be filtered based on software level. Below each row, there are some specific activities, output and control categories. The filtering options as of now are 1) A, B, C, D 2) A, B, C and 3) blank I...

Hello, I'm new to Excel. I tried a google search and I don't think I'm asking the right questions. Google did lead me here where I did a forum search. However, the one post that showed up wasn't really relevant to my situation. I have a workbook with 9 worksheets. The first worksheet is just a...

I have the following macro: Sub FilterByDate() Dim targetDate As Date Dim wsDashboard As Worksheet Dim wsShippingQ As Worksheet Dim tbl As ListObject Dim colNum As Integer 'Define the worksheets Set wsDashboard = ThisWorkbook.Worksheets("Dashboard_Today") Set...

What I am ideally trying to do is to build a dropdown off D2:I2 (day #s). I know how to do that, but I want to build the drop down on another tab and have it bring back the data in columns A:C. I need to be able to filter on the day # and have it return Name, Date, and Qty, but only if the day...

Hi, I've been trying to get my head around how to sort (by multiple criteria) in a filter but can't seem to get it to work. The original filter also included CHOOSECOLS but I have tried to remove that to troubleshoot but without success. The filter (pulling data from a sheet named DATA) is...

Hey gang, Can anyone help me with the final formula in my workbook? I need a formula to populate the yellow cells in row 71. The goal of the formula in row 71 is: If the Member's cell in row 71 has a "1", that member's data is pulled into a master summary tab showing national total of all the...

Hi there. I am trying to write a formula to copy across in the highlighted neon yellow cells that checks to see if 10 different members' info matches the filter criteria at the top of the sheet. Should I add a ghost column underneath with same number of rows, and have each cell check each...

I have a ListBox that is filtered by a TextBox, but I want it ot be filter by a ComboBox as well, This means that If the TextBox is filtering specific values, the values shown in the ListBox must be shown in the ComboBox. This is a visual example of it And this is the code that I'm using for...

I've been seaching everywhere to find a way to auto filter the table (column E8:E) on all my sheets (more than 100) containing a filter that updates when an employee changes quarter (Dw Day week, DWE Day weekend etc.) It would be nice if it would update automaticly or just when someone opens the...

I have a workbook with sheets for each financial year from 2010 onwards. All column headers are the same across all sheets. I need to be able to combine all the sheets into one sheet *BUT* I need this combined sheet to change with the others if rows are added/deleted in any of the other sheets...

I am trying to use the FILTER formula to return only the results that meet a criteria listed on column B. On column A, I am using the UNIQUE function to bring unique values from a different table. Column B has 1/0 values related to the data on column A. In column C, I would like to have only the...

Let's say I have the following table Sheet name: Values A B C D 1 Folio Model Year Status 2 156 Forte 2022 Delivered 3 452526 Rio 2023 In repair 4 785 Stinger 2023 Delivered 5 475 Forte 2020 In progress An I want to fill an ActiveX List Box but only with the values from...

Hi all, i am trying to use filter formula to filter out the result, it works, but if every row use this formula, it will cause #spill! error as sometimes return more than one result May i know is there have any method to update the formula for auto insert the row to avoid #spill? error in using...

=XLOOKUP(E2:E11,A2:A5,C2:C5,,-1) =FILTER(A2:A5,D2:D5>F2) I want A5 to be dynamic to the last cell with a value. I've tried my hand at sequence and index, but it doesn't seem to work.

Hi all, I'm struggling to make some formula work, unsure if i am not applying the formula correctly. for context: I have a table that goes from C1 to GX. (x is dynamic since rows will be added over time) First row is the headers of the table, so data goes from C2 until GX. Then i have a...

I have 2 tables on separate tabs that I would like to search for any row containing a criteria and return the whole row. After converting the data to tables I create a new tab just for my search and am using cell B3 as my search criteria text box. I am using the following formula and no matter...