multiple criteria filters

Hello Everyone, I have a data table and i want to find approximate match against that table, CATEGORY DENIM DENIM NON_DENIM NON_DENIM RANGE NORMAL WASH HEAVY WASH WASH DYE 999 8.00% 12.00% 8.00% 12.00% 2,999 6.00% 8.00% 6.00% 8.00%...

Hi all, really hoping someone can help. Spent a few days now and getting nowhere it feels, and it may just not be possible. I have a workbook with the following: - sheet 1: a master list - columns B4:J containing categories that we need to filter by and then columns K4:IY with the unique name...

I am trying to create a filter that will select 4 different parts. another constraint is: Sometimes a part will be added with a similar name so I cannot specify the exact name. So what I started with is: ActiveSheet.Range("$A$1:$N$6000").AutoFilter Field:=4, Criteria1:="=*A717*", _...

I have a rather large spreadsheet that gives me the following information: 10112 Biloxi MT Manager Trainee BOP Active 2 CSR Customer Service Rep BOP Active 2 MGR Manager BOP Active 1 10112 Biloxi BOP Active 5 This...

Hi I am unable to count using using Countifs with Multiple Criteria filters and data contains Blanks/Null. Can someone please help? <TBODY> Fruits</SPAN> Vendors</SPAN> Quality</SPAN> Fairtrade</SPAN> Apples</SPAN> TE</SPAN> Low</SPAN> Yes</SPAN> Mangoes</SPAN> SA</SPAN>...

I need to look up data from a different worksheet based on two criteria: (Main worksheet) Company (A1), Fund Name (B1) and Stage (C1) A | X A | Y A | Z B | I C | X C | I A-C are company names, I, X-Z are fund names and i need stage data In (worksheet 2) I have the raw data, where the data...

Hello Everyone, I need some help regarding filtering in excel, and would greatly appreciate any assistance. I would like to be able to filter by variable criteria, and possibly by multiple variable criteria. Allow me to explain this as simple as I possibly can :stickouttounge: I have a...

Sorry for the possible simplicity you may look at this problem but I am rather new and need some guidance. My issue Column G has an amount field column H has a one character account field And Column I has a paid Indicator If Column H is 'X' and and column 'I' is blank then I want to sum...

Hello, I have a sheet with data arranged in 5 column: State, Date, Quarter, Year and Funds. The columns quarter and year are derived from using date. I need a userform to gather the filters (user inputs of state & year) and the filter the data. What I intend to do is to write code to provide...