multiple criteria

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

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

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

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

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

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

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

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

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

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

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

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

I have a spreadsheet where I'm trying to put together an IF statement which meets multiple criteria. Outline below: Column B - Type - "Risk" or "Issue" Column I - Probability - "1/2/3/4/5" (validated cell) Column J - Impact - "1/2/3/4/5" (validated cell) Column K - Rating - product of Column B...

I am trying to return a value (a date) based on 2 criteria. Column A has a purchase order, column J has a part #, and column E has the date. All columns have some repeating numbers, but the 2 criteria together makes it unique. Because of the sheet layout I can't use vlookup so I would have...

Good day, I am hoping someone can help me simplify a project to rank our sales force. We need to rank them by 4 criteria and each has a different weight. Here are the columns, criteria and weights: <tbody> <tbody> Weight 0.4 0.2 0.25 0.15 Rep % of Budget % of PY PY $ Change Subjective...

Hi guys! I am having trouble figuring out how to do the following. Basically, I have a spreadsheet that I need to add controls to so the end user can re-sort the log based on how they want to see the data. Rows 1:6 are headers Print Range is A7:AG1525, but range will grow as new rows are...

I have a question on returning X customer's discount percentage Y, based on their Z spend amount.Ie: I have a list of 5000 customers, Various min and max spend and its corresponding discount. For customer John, i can locate John by index match among the list of customers. Then when at customer...

<colgroup><col><col><col><col></colgroup><tbody> A B C D NAME DOI Dept OSHA John 3/8/2019 Grocery Yes Isa 3/19/2019 Perishable No Dave 3/24/2019 Grocery No Phil 3/25/2019 Perishable No Eric 3/26/2019 Perishable Yes Anne 3/28/2019 Grocery Yes Jack 4/1/2019 Perishable Yes </tbody>...

I've been struggling to find a way to identify pairs of entries for which at least of portion of their time overlaps. To make the challenge more difficult, I need potentially overlapping entries to meet multiple criteria before they are determined to be overlapping. I have two fields for...

Hi, I have a table that looks like this: <tbody> Item Class Start End Item1 A 50 80 Item2 A 60 150 Item3 A 120 160 Item4 A 150 250 Item5 B 300 400 Item6 B 400 500 Item7 C 50 300 Item8 C 70 150 Item9 C 150 300 </tbody> If my lookup looks like this: <tbody> Class...