filter advance

Hi! I'm looking for some help in grouping sets of data for when a filter is applied. Example below: Says below is the original set of data - I would like to be able to filter by tests that have "failed". Is it possible to keep all of Test number 2 & 4 showing when I filter for "fail"...

Hi, we have the data in sheet1 and sheet2 and using index and match formula, its working fine but we don't want to drag and drop formula from C2:C4 and again we have used formula in D2:D4, there is any formula from which we can get desired result so that don't do drop down SHEET1 125024568765...

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

Hello my fellow Vba coders My worksheet contains a table where I want it filtered based on two separate dropdown list. The user will first filter cell B3 where the table filters the data accordingly, and then if they choose to, by selecting a value on cell B6, the table filters the information...

hi we have the following data sheet and want to get heading as per given result sheet data sheet...

Hi, we have posted this question on the following url but in this there are some change in requirement, we have around 100-200 entry and taking the result in new sheet only for example we have used the same sheet...

HI, we have the following sheet where we want to check the steps where are work is pending, kindly provide any excel formula we have the excel 2007, 2010 sheet ABCDEFGHIJKLMNOPQRS1WorkStep 1Step 2Step 3Step 4Step 5Step...

HI, we want to filter data from two column to one as per result sheet (Excel 2007 and Excel 2010) ABC1S.No.BarcSecond2132SQ35143SQ35254SQ35365SQ35476SQ354 - 187SQ35898SQ354109SQ354 - 21110SQ354 - 31211SQ357 Result Sheet A20Final21SQ35122SQ35223SQ35324SQ35425SQ354 - 126SQ354 - 227SQ354 -...

HI, we have the following data, and want to filter the data on behalf of the following points. (we have excel 2007 and 2010) (1) Order Not Received and target date is passed (2) Order Received but balance Qty difference is 50 or more than 50 ABCDEFGHI1DateOrderP NameTGQtyRecd. DateRecd...

HI, we have the following data where we have many entry in Sheet1 column A, here we have updated some demo data but we have many entries Product Code&TS4560&&TS6484&&TS2468&&TS4560& (1)&TS4560& (2)&TS4560& (3)&TS8470&&TS8474&&TS6484& (1)&TS6484& (2) Want this type of result in sheet 2, where...

Hi Guys, Pretty new to excel so hoping there's a simple answer to this that I'm not aware of. I work in marketing insight and part of my role is selecting the best customers to send each of our direct mail campaigns to, and I want to create a workbook in where I can walk through our monthly...

Hi Excel Experts, I am looking for one small automation macro to filter the data below and need to keep one set of data from the input to the output. We have three columns below and Col-1 where "Y" is applicable in Col-3 then Col-1 cell value should be base and corresponding Col-2 data...

Hi, I have 8 filtering criteria in a single column, I'm trying to build a macro which would put a filter based on each criteria however the issue is if it doesn't find any value in the filter all other value goes blank and sometimes I'm even unable to put the filter using the formula, request if...

Hello, I really need some help breaking down this formula please :) I currently have a document that I am working on where I have created a field that allows you to search for the relevant information below by entering in the postcode and the suburb. The screenshot below is a sample of the...

Is it possible to create a macro that filters by using the headers name rather then the specific column? If so what would something like that look like?

Hi, Is there a way to create text file base form hundred of ID, and for each text file's content would be IP address as attached pict.

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

Hey, I have around 7-10 unique values in column A and I want to filter by every single one of them and do some copy pasting etc. I just cant seem to figure out how to filter on the first unique value, do some stuff, then unfilter and filter on the next unique value. Any help would be greatly...

Please see screenshots. Tab 2 is the extract I get from the Information System. I would like tab 1 to update when I paste the info to tab 2. I think one of the limitations could be that it will be done in google sheets.