filter

I am trying to do the following on a summary tab: 1. Perform a summary calculation of common part numbers 2. Display the total qty as a unique row displaying the total qty of the duplicate part numbers into col "A" on the "SUMMARY" TAB 2A. If all the rows of duplicate PN qty are 0 then omit...

I have a table like the one attached. I need to get distinct values in column S (client name) but only of the records having a specific column A (supply code) value (OTT23 for example). Is this feasible without using FILTER function? Any help is much appreciated.

Hello- I have a file that changes monthly that I need to utilize vba to filter all unique values (that will change every month) in column D and add up values for each unique value from column L. Any help would be appreciated! Below is a sample of what it looks like. The dates change monthly.

I'm working on a table that references another and returns the number of employees in each of several regions, by year. The source table includes a row for each employee, with a value of '1' in the column for each year they worked: Destination Table: Year Region Employees 2020 a 1 2020 b...

I hope this illustrates what I would like to do i fist have a virtual table filtered for just green products, and then a second for just red , I would like to filter the second table to show only customers or whatever that are contained in the first; EVALUATE VAR ttable = CALCULATETABLE (...

Hi Experts This is the power of Excel - That you start to believe can I go 1 level further. Recently I had a thread - https://www.mrexcel.com/board/threads/filter-unique-values-out-of-a-multi-column-list.1251328/post-6140661 where @Eric W @ISY @Fluff gave me the solution. Due to my system...

Hi Experts, I wanted to get a one column list out a range. So far have been able to extract a multicolumn list. But I want it to be one column list so that it could be filtered further for unique values. Got kind of stuck somewhere. Please help Thanks in advance Underneath is the formula I...

Hello! This sounds so basic, but I swear I've searched for a long time and can't find exactly what I need. I have a list of (usually thousands of) contacts with multiple columns (E.g., let's simplify to: first name, last name, personal email, work email, phone) that I need to clean against...

I have a list of names and all the countries. Column 1 is filled with names and the following columns represent all the countries of the world. In each row, there's an 'X' under the country that person has visited. On another tab, I'm listing some of these names using the formula FILTER. In the...

I really don't know how to state this one better. I'm creating a spreadsheet that will take a customer's email address and Generate an email to inform them who the contacts for their selected job area are. I designed a sample spreadsheet: And my goal is to produce the email so it has a link...

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...