multiple criteria

Good morning or afteernooon to everyone: I've this little piece of VBA code that it's not working: Select Case PAc_ALACase Is <> 5, Is <> 10, Is <> 15, Is <> 20, Is <> 25, Is <> 30, Is <> 35, Is <> 40 Do whatever End Select Where PAc_ALA is an integer. Anyway, I tried in a different...

Hi Trying to create formula foe the below table which has multiple criteria x Qty x Duration (with two dates) Attached sample file: Eg for Apple. Same as vlookup to be made for all items like carrot, beans, tv from nested cells. After this, the results will be converted to Pivot table /...

I have a situation where I have 4 contract types and many clients have multiple contract types. I have created a spreadsheet with a "switchboard" so I can select the contract types I want to include in my sales estimates using "TRUE" or "FALSE". I can also set a percentage threshold based on...

Hi all! I have a question regarding on how to get multiple values from different sheets with multiple criteria. What i basically want to do is the following thing: I have multiple weeks (Week 1-52) in all these weeks i fill in the hours that i've been busy on a project with a certain sub-task...

I have two sheets, one named, "DATA" and another named, "STATS". I need to enter a formula in a cell in the "STATS" sheet that will count the number of unique dates in column G from the "DATA" sheet but ONLY IF column F contains the text, "JC". <tbody> F G JC 22/10/2017 JC 22/10/2017 AF...

Hi! I've using cycle macros for searching in each column certain value and then comparing values in adjacent columns in order to get values to show or similar matters At this moment I found out that there is a way to call formulas from vba code via Application.WorksheetFormulas and at the same...

Hi, I have a pivot table that is based on a data set which is updated every month. The pivot table has a multiple criteria filtre in order to select the month ie 1/1/2017,2/1/2017,etc. I want to select the months from an external cell, meaning that if I type in 5 that cell the pivot table...

Hi all, With help from the internet, I was able to find out the first and last test attempt for a user using an array formula, but I'm having trouble adapting it to look at TWO criteria (Name and Course). Because it is only currently looking at name, users that attempt Course 2 more times than...

Hi All, I have an issue that I am hoping someone can help me with. <tbody> 31/10/2017 Manual Entry Orange Manual Entry 31/07/2017 31/08/2017 30/09/2017 31/10/2017 30/11/2017 Apple 65,906.16 64,208.91 60,553.10 61,147.29 (65,168.44) Orange 82,423.36 79,439.45...

Hello, Im trying to write a formula that calculates an average for a location under a specific period. I have to specify the start and end dates and also the location and then get the average. With one location I was able to calculate the average using averageifs, but if there are multiple...

Hi Folks, I want to be able to get a sum for a column using multiple criteria in at least two other columns. I don't have a problem when using multiple criteria in only one problem, but I can't find a way to have multiple criteria in multiple columns. An example follows: Product Supplier...

Hey there, I have been reading around this subject for a while now and I can make it work for 1 value but not down a whole column. Anyway, I am looking to have and index and match using 2 criteria in separate columns. But I created that, I could not drag it down my destination column (probably...

Hi There I'm new to excel and was wondering if you could help me :0 So I have a spreadsheet with 2 worksheets. The one has 3 columns: Brand, Date, Traffic The other one contains a table that should only show the traffic amount my website received based on the brand and date in the worksheet...

Hello. I need to count the number of donors who have contributed as of 09/30/2017 in the North America region Only. How can I do it? I am using the frequency and match formulas, but I don't know how to use it with multiple criteria, such as, dates and region. I have this data, Region/...

I am statistician for football team. I have created a list of team stats for the entire team, but am wanting to create separate lists for individual categories such as rushing and receiving, but only include those individual players with at least one attempt. The following is a sample from...

Hi, I need some help with an excel file.I have tried to do it with an index match function, and some cells come up with #NA other cells will come up with a value. Every month I pull a report (Discover Report) that has three columns. The first column is the project number, second column is the...

Hello, Using 2010 Excel, I have 192k rows and 6.5m filled cells of data that I need to be able to match certain criteria to and pull the matching rows from the data sheet into another sheet. It also needs to be as fast as possible (no looping?). My research took me to these posts regarding...

Hi Guys, First post, hope I'm doing this right! I have Table1 which contains the values I need to Average into a column in Table2. The selection of rows in Table1 for the Avg is based on multiple criteria matching every row of Table2. My problem is with solving the requirement for me to use...

Hi all, I have hit a dead end and am in need of some help. Apologies in advance as this scenario is slightly lengthy I want to ensure that you all have the full information. The data that comes out of the accounting system is raw data dumps from 2 SQL data tables, one gives me all the purchase...

EDIT: I tried changing SUMPRODUCT to just SUM and that works. How do I make SUMPRODUCT work to get the output I need? Hi all, I've got a long SUMPRODUCT formula to search through a big database and sum the range of cells that match all criteria. I've checked all individual components of my...