multiple criteria

  1. K

    Need Vloopkup Formula for Multiple Creteria + nested cells + multiply x between 2 dates

    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 /...
  2. M

    Help with Sum based on criteria that is a mix of text and numerals

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

    Multiple Sheets, Multiple Criteria

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

    Count unique dates based on criteria from another column.

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

    VBA Match+Index formulas call for multiple criteria

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

    Linking cells to multiple criteria Pivot table filtre

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

    Finding MAX number based on 2 criteria in a series without helper column...

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

    Array Issue, Vertical and Horizontal criteria

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

    Average multiple criteria and ranges

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

    Multiple Criteria In Multiple Columns

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

    Index & Match (2 column criteria) multiple values

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

    How to get value in cell in one worksheet based on criteria from another worksheet

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

    Count Unique Text Value with multiples criterias

    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/...
  14. D

    Trying to rank data based on certain criteria

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

    Index Match with Multiple Criteria

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

    Large Data VBA, Conditional, Multiple Criteria Copy Row and Paste into Sheet at Speed

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

    Find Avg of weighted values, dependent on multiple criteria, with weightings in 3rd table

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

    Setting out data and or multiple ranges with Multiple lookups.

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

    Excel limitation or formula (sumproduct with multiple criteria) #Value problem?

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

    Multiple Criteria Index Match - #N/A!

    I read many posts and researched the Index Match function & still keep getting #N/A :confused: I have 2 sets of data that I need to compare for a data conversion project. I need to update the old dataset with new account, subledger, department values in order to get the closing balances to...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top