# multiple criteria

1. ### Return multiple matches with multiple criteria as text

Hey, I have read some similar threads here and tried some of them but still no solution for me. I have a large database where I would like to list all destinations of each driver for certain days. The main challenges are 1. any driver can appear in any of 3 columns, 2. there can be more than...
2. ### Largest Value based on Multiple criteria

Hi there, I'm working with a data sheet and am trying to get the Nth largest value in a specific column based on multiple criteria. My single criteria formula works fine, this is it: ={LARGE(IF('Sheet1'!C:C=3,ABS('Sheet1'!W:W),""),1)} However, I run into the #VALUE! error once I add another...
3. ### Count Unique Dates With Two Criteria (with Photos)

Hello All! I'm trying to create a formula that counts the number of unique dates with two criteria. I've actually searched within this forum and found a similar question, however because it was case-specific and the conditions differ to mine, the same cannot be applied to mine. The one with 2...
4. ### Excel to return a value in a column, if multiple criteria meets

I tried to return a value in sheet1, column A (vertical), to sheet 2 (Horizontal format), if the "Process_Step" and "WO" is matched. As the data is huge and there're many columns, I do not know how to specifically to use the index and match or vlookup, to return the column A value (Date) if the...
5. ### Sumifs using both date range AND text

Hello, I'm wanting to sum a specific column if it's within a specific year and meet's a specific criteria. For example (please refer to attached pic). I'd like the sum of all Dues & Subscriptions in 2017. So far I've been able to use the text to come up with an amount using the following...
6. ### Combine and Sum Lookups across multiple rows using an array formula

Hi, I need to convert several currencies across multiple rows into GBP by looking up a conversion table and then provide the sum in GBP. I haven't been able to come up with an elegant formula (an array type formula maybe) to keep it short and simple. for the SUM in GBP, I've got the...
7. ### Multiple Criteria Lookup with Date Ranges

Hi everyone, I need to create a lookup which returns a value based on 1.) an employee ID 2.) a date range. I have included an example image. Basically, I need a formula for column H which returns the correct Union of an employee, based on their ID and the award date (column G). The dataset...
8. ### Excel Formula Multiple Criteria with Moving Header Changing to Different Column

Hi, just wondering if this is a possibility with the Index/Match formula. Or is there a better formula when I don't know the column position of the header? The new report we get now, the header name is not always in the same order so the index/match formula isn't cutting it anymore. Example...
9. ### Populate rest of Userform based on two ComoboBox Values

Hey all, I am trying to quickly get order data from a single sheet of over 3000 entries using a UserForm to make it as simple as possible for staff. So far i've made a userform that i want to use containing a number of text boxes: "Cust ID", "Order #", "Item", "Part No", "Date Ordered"...
10. ### Find related items based on multiple criteria > index+match multiple criteria or somthing else?

Hi all, This is a challenge, at least for me. What I'm trying to achieve is the following: I've a big list of items with several specs. I want to project the matching items (with the same specs) in columns after the item to match. Simplified example of the data: <tbody> Item Spec 1 Spec 2...
11. ### How to solve a issue with three criterias

Hi, I would like some input/pointers on how to solve this, I'm not sure where to begin... I want to write Active, Not active or Ignore in column E based on three criteria. As you can see in the table, a person can occur 2-3 times, even 6 times in my orginal data. Data is sorted on column A. If...
12. ### Lookup with multiple criteria

Hello all, I'm trying to find a value in an array using multiple criteria. Basically, what I would be looking to achieve in the below example would be to search for A2 in E1:E4, where B2 is also greater than G2:G4, and less than H2:H4 and return the answer from F2:F4 This should output Zone...
13. ### Countifs formula across multiple sheets

I need to compare student IDs on sheets Adds Drops (Column B) to Sheet2 (Column C), and then cross-reference that with the date on both sheets: Adds Drops (Column B) and Sheets2 (Column I). If the dates on Sheets2 (Column I) is more than 7 days later than the date on Adds Drops (Column B) for...
14. ### Rank using 3 criteria

Hi there. I've been struggling with a problem for almost a week now. I'm trying to assign a rank score to some data based on 3 criteria. The end result should be in a single cell (in fact, I'm using nested if statements to add different combinations, but this is the toughest one). Criterion 1...
15. ### Conditional Formatting For Multiple Strings of Text in One Cell

I'd like to use conditional formatting to shade a cell that contains, for example, "G8 Math 2". If it says, "G8 Math 3", I'd like it to be a different color. And, if it says, "G6 Math 2", yet another color. Some of my cells also contain additional text, such as a co-teacher's initials, and I...
16. ### Excel formula/function to subtract until 0

<tbody> A B C D E AA AB AC 1 Invoices 2 Year Remaining Task Funding Invoice Task Fund Amount 3 2017 3014.03 97 M 0 5 2015 6460.71 98 L6 60.71 98 L6 60.71 7 2018 580.28 99 F 0 100 A 5600.74 10 2019 6956.39 99 F 0 11 2017 5510.74 100 A 5510.74 13 2018 8737.52 100 A...
17. ### VBA to search multiple values and multiple workbooks and return filename where found

I am attempting to create a tool where I input a list of values (20-25 as I don't want the code to take forever) and then Excel does a search across multiple workbooks and for each value in the list and returns what workbook it is located in and where it is within that workbook. On another page...
18. ### find nth smallest value with multiple criteria

Hello everyone, I am stuck to find nth smallest value from a range of cells with multiple criteria. I have a formula to extract nth largest values but not being able to reverse that formula to get the nth smallest value. The formula i'm using to extract nth largest value is as follows...
19. ### SUMIF name and total hours are within specific date range

Hi guys, Hopefully someone out there can help, cos this has me beat. I need to keep a total of hours, for people working shifts that can be different lengths. I have a formula in place in the ‘Shift Start’ column that does this for the month...
20. ### Average with Certain Criteria in column

Hi, wonder if anyone can assist, I am trying to work out an average from multiple criteria that is in the same column. I have criteria in column F and ratings from these in column H, but from the criteria I don't want to include certain elements. I have made a range list of the elements and...

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

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