filter advance criteria

Hey again everybody, I've "upgraded" to Office 2010 (sorry, not going to pay for a subscription, at least not right now) and I'm trying to learn about the FILTER function. For example data, I have (in my sheet) columns G and H, beginning at 1: Date Amount 1/1/2023$ 112.642/4/2023$...

Hi Experts Got stuck up in a strange situation. Tried copying XL2BB from original file - It failed. So copied the actual data to a blank worksheet to explain a situation. What I need to do - Filter dates based on Financial year (April 1 to March 31 - in India) - May see the blue highlighted...

Hi all, I have a spreadsheet containing test cases, where each test consists of multiple steps. The spreadsheet has a column (Column S) that contains the names of individuals assigned to each test. I want to filter the spreadsheet so that only my name and my assigned test steps are visible. When...

Hi, I have a list of managers and their management levels and what I need is to validate if each manager has the right management level. The issue is not all the managers have the same exact management levels, i.e. some managers have 1 level and others may have multiple. I need a formula that...

I have a list of entries in a table, and I'm trying to use Advanced Filtering to filter this list in place. The advanced Filtering criteria are in a second sheet and I have them setup as follows : <>Get* <>List* As I understand it this should filter out any entry beginning with "List..." and...

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 All I am using the excel for the work ticketing system register and in process to improve my system I am looking to implement flows. However my document is xlsm and flows will not work on macro documents. The only reason I am using macro is to auto filter upon the opening document...

hi, i have a dates table. (eg. below). I would like to use a query to filter only the last date for the Financial Year ending March 31, and the latest date available. (i.e the yellow shaded ones in table below). would appreciate any help here. thanks in advance.

Hi, I was wondering if anyone can help. I want a filter sort out table on one sheet to a breakdown on another sheet. To explain, I have two sheets. Sheet1 is Archived Reports. Sheet2 is a "Dynamic" Calendar. I need both of them to somehow connect in a very specific way. On Sheet2, I need to...

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

Good Day all and Happy Monday. I think there is a simple solution to my issue but I am just not getting it right. The solution I am trying to get is too filter the data in range A20:E20, which works if full range has data in ALL of the cells. BUT the problem is when there is a blank cell in this...

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

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 don't have access to VSTACK yet, so I am using a workaround to stack many dynamic arrays on top of each other in a list. To do this, my helper array formula is as follows...

Hello! I have a range with columns "Product", "Type" and very many date columns, the one on the left in XL2bb. This shows the inventory for each day. Please note that in reality the products, type and dates are way more than in this example. I need to create a table (the one on the right in...

Hello. I desperately need some help with a csv file I need to create to upload products onto shopify. The aim of the game is to sort through the 22 000 lines of data, in order to create a new list which contains maybe 10 000 products with TAGS. This part I've done. (The other 12 000 lines are...

This is my current script: Sub FilterDateRange() ' ' FilterDateRange Macro ' Filter a date range ' ' Keyboard Shortcut: Ctrl+Shift+P ' Range("I2").Select ActiveCell.FormulaR1C1 = "=RC[-1]" Selection.AutoFill Destination:=Range("I2:I" & Range("B" & Rows.Count).End(xlUp).Row) Range(Selection...

Hi Everyone, I have attached a spreadsheet and highlighted in yellow the column K I would need to be filled with a formula (spill formula only so that it is completely automated). Column I and J: This is a spill formula using Unique, Filter and Choose function. Column K: I would need a spill...

Hi, As my excel version does not have filter, sort, unique functions I have to use other set of formulas to search the drop down list in data validation. Column C Column D running shoes adidas cooking salad eating chocolate cookies sleeping at friend's house baking cookies...