multiple criteras

Hello All, I have tried to formulate something that searches through rows to meet 4 criterias. If all criteria is met I need the row number or the entire row returned, if not continue the search. Half of my criteria is straight forward BLUE=BLUE, GREEN=GREEN while the other two needs to be...

I apologise if this has been asked before but I can't seem to find an answer. I need the end result to be a discount given based on the product code, date range and quantity. For example: Based on the order date, product code, and quantity from the below table the discount should be -15.00...

Hello, I would like to retrieve data from an Excel table into another table. In my table I have to retrieve in column AX, the data according to two criteria in column E and in column F If in column E there is "VMO" and in column F there is "EKZEK" then take the value in column "AX" on the...

Hi all, I'm attempting to consolidate a big block of data with two columns and a reference to a month into a summary table and I can't seem to get there. Essentially I want to sum for example, all the items in the reference table that are CAPEX and Labour for the Month of September into the...

Good Day to all I am trying to replace below formulas with a macro code. =Min(if($C$7:$C$14940=$N7;if($D$7:$D$14940=M$7;$F$7:$F$11940))) =Max(if($C$7:$C$14940=$N7;if($D$7:$D$14940=$M7;$F$7:$F$14940))) I have 2 criterias Criteria 1 : Plate Number like (PN AU 2095) Criteria 2 : Period like...

I have a problem and in desperate need of help. I am trying to create an analysis tool to compare the information in two workbooks and return data to the source workbook. For example; I have two work books, one current and one history that I want to compare and return the status and status date...

Hello! I'm having trouble with this filter macro below. What I want to do is to filter everything except "jan" so I've written all the other months in the criteria. But for some reason it filters everything and the sheet becomes blank. Can anyone help me with this one? Selection.AutoFilter...

Hi, I need to write a formula to sum the values in column A based on a number of conditions, including one that would be the sum of the values in a number of columns. Using the following example, I would need to add the values in column A if condition 1 = Australia and the sum of the values in...

Hi! I'm a beginner at VBA and I need some help. I'm using three data sets with district data. Some district have the same name so I want to apply an ID number instead of using the district names. I have a numeric ID in one of the data sets. I now want to insert that ID in the two data sets...

I'm pulling my hair out trying to figure this one out. I have a fake mock-up spreadsheet but the forum will not allow me to post attachments. I am trying to do a nested IF/AND formula that will give me the EXACT name in a specific cell on a different worksheet. Example: "If the obligation...

Hi, I have a spreadsheet that that I am trying to run a macro that does an Autofilter on a range Sheets("Criteria").Range("A1:L2"). Here is the VBA code that does the autofilter: Sheets("Source").Range("A1:L108784").AdvancedFilter Action:=xlFilterCopy, _...

Hi All, I am new to this forum and looking for some assistance for creating a macro for a process that takes me about a day to complete. Any help would be greatly appreciated. And Thank you in advance! Below is the table: <TBODY> ProviderName TotalCharge DateOfService Pairing John Smith...