criteria

I am trying to figure out how to reference individual column filter criteria in an IF/Then statement. I was able to use AutoFilter.Filters(CF).Criteria1 where CF is a variable for the column. Using this method, though, if column A has a criteria selected, then column B shows up as having a...

I am wanting to get some data from an Access table based on multiple criteria and I'm not sure if my criteria is working and I can't seem to find anything that would let me verify it. the query as it stands isstrQuery = "SELECT Name, Wage, Pre_App_Adds, Food, Home_Start, Other, Mileage_Pay...

Hi I am not able to change active sheet based on 3 criteria, I have done with first 2 criteria but third one is not able do do. 1- change tab name according the active workbook 2 should be add MTD in Sheet name 3- Add Month name (MMM) based on next sheet cell value. Example:- my file name is...

Hi all, Sure this is simple for an expert. Below is the formula to return the value of A3 if the values in row C add to zero. =(IF(SUM(C3:F3)=0,A3,0)) How do I sum the total of all of all the values from A3:A15 that meet the criteria using relative cell references for column C criteria? Thanks!

I need one of my match criteria to be an or statement. I am currently using the below =INDEX($I$37:$I$1128,MATCH(1,INDEX((D37=$D$37:$D$1128)*(F37=$F$37:$F$1128)*($G$37:$G$1128="Base"),0,1),0)) I want the last set to look for "Base" or "Allowance"...

I need to look at data and return a list of unique numbers from column C where Column A, B match certain criteria. And a different set of returns where A,B, and D match certain criteria. I have data that basically looks like this: <tbody>#DAE7F5[/URL] "] A B C D 1 Criteria1 Criteria 2...

=SUMIF($C:$C,$C$4,D:D) The criteria in this formula always needs to reference the cell "ActiveCell.Offset(-1, -1)". Is there a way to do this through VBA? SUMIF(C3,R4C3,C) This is what is looks like on VBA. Thanks

Hi I'm learning about COUNTIFS and I don't understand why this is working in one row and not another. In my first cell in question My Criteria is TECH (E4) in Ranges A2 to A20 and R(G4) is ranges B2 to B20 : I'm using =COUNTIFS($A2:$A20,$E4,$B2:$B20,G4) - and it seems to work, it counts 4...

Hello guys, Currently I have a set of commands in VBA like: for n = 1 To 274 port_return.Columns(3).Cells(n).Value = WorksheetFunction.AverageIfs(monthlydata.Columns(2), monthlydata.Columns(3), "=W", monthlydata.Columns(5), "<=0.3") port_return.Columns(4).Cells(n).Value =...

Dear Folks, I need to lookup of a quantity plan value based on a Date and Area. I have 5 columns from B to F B = Date (is duplicate) C = Area (is duplicate) D = Scope of Work E = Actual F = Plan H1 = Date - criteria 1 H2 = Area - criteria 2 H3 = Result In H3, should be a formula to lookup...

Hello guys, My data set is like this: <tbody> Stock Return Criteria1 Criteria2 Percentrank.INC 1 0.1 W 0.9 2 0.3 M 0.7 3 0.2 NA 0.3 4 0.1 L 0.5 5 0.5 M 0.33 6 0.2 W 0.88 7 0.1 W NA 8 0.4 L 0.2 9 0.2 L 0.77 </tbody> What I want to do is to run double sorts in VBA...

Hello All. I would be grateful if somebody could help me please. I have a list of names that exist in D14:D42 which I'm endeavoring to copy the text to cell D4. The criteria for this list exists in column G14:G42. Using sumif, as shown below, it works if numerals are used but not for text...

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

Can anyone point me to a good resource for learning how to do some basic analytics in Excel? What I'm trying to learn how to do is look at all the operating and maintenance costs of hundreds of facilities and determine which ones cost the least/most overall. Also to look for cases where a...

What is the best practice for multiple criteria Vlookups? I have a table with 5 columns. I need to lookup a value based on 2 sets of criteria. Any suggestions?

I've read several posts about how to use autofilter with more than 2 criteria and the answer seems to be to use an array - I am trying the following but get a Type Mismatch error on the Criteria 2 line? Criteria1 = "*Meeting 1*" Criteria2 = Array("<>*at their Stand*", "<>*Table...

Can anyone show me how I can delete all the rows after the last one found in column C with the criteria 'Not Available'?

Hello! I have an issue writing a formula that I hope has an easy response. I have a dataset with people who have multiple rows of data relating to them. If a certain number of rows meet criteria (eg, are within a certain time period of each other), I would like Value Y on that row to be blank...

Hi, I've created a macro to filter by a particular search term and to then copy/paste the selection to another location and delete the rows of data from the original worksheet. However, if the search term is not available within the applicable column then my macro ends up copying/pasting all...

Hi, can anyone advise what type of formula would be best if I wanted to create a dashboard that listed the last 10 transactions based on multiple criteria? In my case it would based on the account status, i.e., Approved, Declined, Pending and the second criteria would be the submitting broker...