multiple critera

Hi, I'm trying to develop a Index/Match function in VBA with multiple criteria (using the "&" as in an excel function) - but it doesn't work. Does anybody know what I'm doing wrong? Function prove(X As Range, Y As Range, Z As Range) A = Application.WorksheetFunction.Index(X...

hi, two questions: wondering what the most efficient way to write these would be - without just combining multiple countif functions on top of one another to do this without using an array? 1: count the number of times any of the following appears in column R - ABS, BND, or FUND; while...

Hello All, I've started playing with VBA some days ago, thus I'm new with Excel coding. Below is a simplified version of the sheet I want to extrapolate the data from (sheet name "Data"): <tbody> Customer Platform Program Motor Type A 1 pr1 aa A 1 pr2 aa A 1 pr3 aa A 1 pr4 cc A 1...

I have two issues that I am looking for help with. The first, is to create a dynamic list of results for items matching "Horse" in column J on Sheet 2!, "Ball" in column I on Sheet 2!, and that do not contain the word dog in column A on Sheet 2! The second, is that while I have calculated the...

Hi This is me first time posting on this forum, so hoping someone can answer. I have data in the below sample format. I am trying to get a record count when the values in column 1(Week) and column2 (Name) match together. For example, User1 has three entries for 7/14/2018. So in column3, I...

Hi there, I am trying to construct an IF Function for the following problem: Data: 5 collums of data (A,B,C,D,E) and 33 participants. Conditions: define person as 'high risk' if either '3 out of 4 values (A,B,C,D) are smaller than 10' OR if '2 out of 4 values (A,B,C,D) are smaller than...

I toyed with this all day yesterday. Been working away at it all morning and still can't whip it. I think it will be relatively easy for someone with some VBA experience... I'm just not quite there. So, basically, Ron de Bruin's code from this page works great. Does just what it's supposed to...

I need a formula to return a unique list of values in (A3:A6) of values from (D2:D6) that are in the column (E:H) that match the criteria in (B1) and have an "x" in Rows (2:6). Need column searched to change based on value in (B1). Thank you:) <tbody> A B C D E F G H 1 Criteria...

I have searched all over for a solution to this and I am beyond flummoxed. Don't let me down... My data is in two columns (Diagnosis and Date) and I need to know the 1st - 3rd most common Diagnoses within a particular date range. Diagnosis Date Autism 1/31/18 Down's Syn 12/5/17...

Hi Everyone - I'm looking to create a sum formula to capture multiple criteria and I am open for suggestions. <tbody> Jan Feb Mar List: List: Car 1 1 2 Car Jan House 2 2 1 Airplane Mar Airplane 2 3 3 Boat Boat 5 5 3 Formula: XXXX </tbody>...

Hi all, Below is a sample of a table on a worksheet (we'll call this one PRODUCTS): <tbody> ITEM DESCRIPTION LIST PRICE COST PRICE UNIT ANGLE BAR 1/2" X 3" X 3" $0.62 $0.52 LB ANGLE BAR 1/2" X 4" X 4" $0.31 $0.26 LB ANGLE BAR 1/4" X 1 1/2" X 1 1/2" $72.67 $60.56 CWT ANGLE BAR 1/4" X...

Hi, In this scenario, I need a formula to return a specific value based on (1) a criteria with an exact match, and (2) a range criteria where there is not always an exact match. Table 1 contains the criteria of the lookup (Year and Number), as well as the value I want the formula to return...

Hello, I have a problem getting results with set of criterias that override next one within one formula. So, i have the following several data: - number of days - destination 1 - destination 2 - unexpected delay reason first criteria is easy, if shipment arrives in 1 day or below then value...

Here is a sample of my data. I am trying to rank associates by their SQscore as long as they meet the minimum number of surveys returned (SQ Survey Count). The minimum number is based off the average number of surveys returned, 13.8. What I hope to see is =Rank associate by their SQ score, but...

Hello, I am trying to get a excel formula or macro that will allow me to extract specific fields from an excel table given 2 criteria (filtering). For example, I would like to only look at data in Column B whose criteria whould be "Boats" and filter column E to only show those fields that are...

I'm trying to replicate the table below. How can I sum the total orders for each week with duplicate date values as column headers? The data is dynamic and the column dates will change, so I was wondering if it's possible to sumif the table array using date and week as criteria? Table...

Hello, I am trying to figure out a way to get a count if certain criteria's are met including an AND function. Is this possible? Example: I am trying to get a count if Column B & C both do not equal "0", Column A equals "GC", and Column D equals "Active". Is this possible? I currently tried...

I need a macro to match/find Rep list and ID on Sheet 1 with Sheet 2 then copy and paste Skill Level from sheet 2 under the correct Skill on Sheet 1. I have a list of over 300 Reps and about 20 different skills and each skills has a levels ranging from 1-8. Below is a quick a example of how...

Ok i need help with a formula. I am analyzing column C. every time the text "2.5" appears in C I need to report the value of the corresponding cell from column D. Example : c26 and c39 have the text "2.5" in them, so I need to add up the total of cells D26 and D39.

Hi Everyone, As you can tell by my username, I am very new to Excel VBA. I just started really utilizing it when I first realized that I can record a macro; however, as I continued it, realized what a powerful tool it can be for my work place when utilizing various data sheets. So far, many of...