filter advance criteria

Hello, I currently have these formulas that calculate data from another tab's table, but if I filter data out of the table, my formulas still calculate the filtered out data. I'm pretty new to excel, but I've read a few forums on using SUMPRODUCT to get the results I want but not sure how to do...

Hi All, Good Day .. :) I just started learn more about excel deep nowadays, I got promotion in office. I was assigned to small task in excel, which a am suck now, can anyone just lift me up from this issue. I have some multiple sheets with dynamic rows to be updated daily and another mail...

Hi everyone! I have two reports that I merge based on a unique identifier from Report A (database) which is normally present in Report B (ticket system report), but not always. The Merge ends up with two columns with employee names (one from Report A and one from Report B). From this merged...

Hello! I am quite new to Excel Macros/VBA and I could use some help with this problem I'm facing: Year Week # Doughnuts Shop 2020 1 34 Krispy Kreme 2021 25 23 Dunkin Doughnuts 2021 3 34 Crosstown Doughnuts 2020 32 354 Dunn's Bakery 2020 51 98 Bread Ahead Bakery...

Hi there, I am new to the forum since today because I am facing a problem highlighting duplicates in a large Excel file (at around 200.000 rows). Situation: Our suppliers sent a list with over 200000 rows in a file. I only need 1800 of them. I can identify the 1800 needed rows by the SKU...

Hello, I am using Power Query to pull multiple data sets into a single workbook. I have a table within that workbook that contains a dropdown. What is selected in that dropdown determines how the data pulled in by Power Query gets filtered. See attached for further explanation. It works...

* how to Apply Condition Formating in Particular Cells At a time, (Condition : IF then " Available Qty " <1 to Highlight Cell is RED color). * This condition Apply but Not properly Working , Pleased help to solve this query, I try to use Multiple criteria using this condition formatting.

I have this code: Dim sapconect, Manual As Boolean Dim Carpeta As String Dim Col As String Dim Archivo As String Dim ArchivoTrabajo As String Dim Fecha As Date Dim Criterios() As String Dim ReporteSAP, TW As Workbook Dim MacroTAB As Sheets Dim UltimaLinea As...

Good evening everyone!??? I wanted to kindly ask you for a send as I just couldn't find a solution for over a week now .... In the column under the writing (TEST) the formula should be entered, and what I would like to do is calculate the UMCSI values corresponding to <3% and> 2.8% of GDP for...

Dear All; i am facing some problem in counting the numbers actually i have one column and it contain thousands of data both in numbers and in strings/ alphabets. can anyone help me in this regard how i can count only numbers out of it....

So i'll do my best to try and explain this. I have a spreadsheet with 2 tabs (DataExport; FilterCriteria) The DataExport tab is every computer i pulled from active directory (real long list) Column A is the PC name and Column B is the OU it resides in. The FilterCriteria tab Column A is a list...

I am having an issue with looping through my advanced filter that loops through a data validation list then needs to copy each filtered data result into one sheet, one after another. I am able to get the data validation to loop through each drop down selection and filtered each persons results...

I am looking for the advice of experienced Excel users regarding the "translation" of a web-based application into an Excel spreadsheet and really hope to get some useful input regarding this matter. Since year 2014 I've been working on a rather complex lottery prediction system. It is a...

Whenever I try to do this it ends up deleting one or another filter. It is very not surprising to me as it filters same columns, But it also happens when I try to filter value over say 300, which seem to be different columns. Is there a way to hide blanks and show top 10 or alternatively hide...

I need some help as I get an incorrect result and I can not solve it. I have a table with following fields: - Ordertype ("Actual" or "Forecast") - CustomerNumber - OrderNumber - DeliveryDate - Plant - Material - Volume I have following measures - Sum of Volume = SUMX ( FactData...

Dear All, I have two tables as mentioned below Master Date Table No.1:- <tbody> Serial No. Quantity of Cards Start No. End No. Invoice No. 1 500 193201 193700 1A 2 1000 199701 200700 1B 3 1000 214301 215300 1C 4 1000 223101 224100 1D 5 1000 235101 236100 1E 6 1000 239601 240600 1F...

I have a spreadsheet w/ approximately 40K lines of data. The data is formatted into 3 columns – employee name; week ending; avg. hours worked. Is there a way for me to filter this data in such a way that it omits employees who do not have any hours or entries for the prior two weeks? In the...

Hi, so I've been looking around for a kind of self-project that I have in mind. I got a list of different descriptions with variable components, basically my idea is: if I have a certain amount of this component and a certain amount of this other component, display all the matches based on the...

I'm new to Power BI. In a simple barchart i want to filter one specific dimension: For planning category A I want to see my data from jan till dec. For planning category B I want to see my data from feb till dec. When i filter using the visual filter i set a filter voor planning category A...