criteria

Hi All Just a quick one - can I check the error handler covers all my autofilter criteria? I can't avoid the errors occurring on any of the criteria, I just want to skip over. Sub DataRaw() Sheets("DataInput").Select On Error Resume Next Selection.AutoFilter...

https://www.dropbox.com/s/vcgf5rfenswgheu/Checklists.xlsm?dl=0 Hi, I've been working on this for a while. I have info from one tab that I'm looking to have transferred to another sheet based on if the criteria is met. Anyone able to help me out? Copy the whole row to another sheet if criteria...

Hi I am unsure how to attach an example workbook for my query. As you can see from the image above, I have Company, which has two data sets associated with it - Product and Category. I am looking to allow someone to input the product and category then be given a , separated 'list' of...

hi I recorded 3 macros so I could see the code for each and hopefully compile something which will filter for all 3, as the standard Excel filter will only allow for 2. I am trying to filter to only leave rows with a zero, a blank or that are >=30 The code for code for each came up as...

I need to sum deposits for each account number for deposits that have valid codes. I've tried SUMIFS and SUMPRODUCT, and run into the same problem of setting criteria to a range of values (E2:E6). Here is where i'm at from a SUMPRODUCT path: =SUMPRODUCT(--($A:$A=$G2),--($C:$C=$E$2:$E$6),$B:$B)...

Hello: Is there a formula that can count only the visible and unique values in a column, based on criteria from another column? This array formula I have counts the unique values with criteria, but it ignores filters and counts non-visible cells...

Id like to write a formula that has an if with more then one criteria but nothing seems to be working. =if(n1="ablation", i want to look in a table for two criteria and return the amount in column H.

Hi Guys, I’ve hit a stumbling block with this, hoping someone can help please? I’m looking to use some VBA code in my userform to find data from multiple criteria. Table EmpID Date Reason 123. 24/10/19 Off 345. 10/10/19. AL 123. 25/10/19...

afternoon all. Just chasing some feedback on a sumproduct average style formula I have; Col A - Supplier Col B - Month Col C - Income I'm wanting to average Col C based on certain criteria from A and B i know this isn't it - however similar to. =sumproduct(--(A:A="Supplier...

Hello, I am trying to figure out a IF formula to say how may criteria mach with some codes. I have made a simple graph. Goal is to find a patient with two Codes specific codes, which is 96365 and J0984 <colgroup><col span="2"><col></colgroup><tbody> Location Patient ID Code Hospital 1 1...

Hi Team, Need your help in understanding the countifs formula, when I give More Criteria in Array It gives different result. Below formula gives Correct result. =COUNTIFS($H:$H,"South",$I:$I,"NY",$J:$J,"Pending") =SUM(COUNTIFS($H:$H,{"South","North"},$I:$I,"NY",$J:$J,"Finished")) Here...

Hi all Im using the index match feature with multiple criteria to get a returned value, but its slowed the sheet to a crawl. Any other ideas to return the text value? Im not great at VB I should mention its a shared document and I think arrays have issues with it being shared...

My SUMIF isn't working, and I'm wondering what I need to do, or if an alternative is needed. Basically, I need to total up some profits if they were earned during the current month, whatever that may be. I have a helper column that uses MONTH(B2) where B2 is the Scheduled Date. Then I put the...

Hello, I need a simple MIN formula with 2 criteria. Below Is the table <tbody> component description qty a systematic 10 d non-systematic 62 c systematic 84 b systematic 56 d systematic 3 b non-systematic 1 a non-systematic 9 c systematic 84 b...

I've been trying to create a formula with multiple criteria, and I can't do it. If there is any number in column C, then I need to look at the dates in two columns (J and AB). If either J or AB has a date more than 28 days ago (based on today), I need it to count how many students have no call...

Hi everyone, I have an excel problem that I am stuck on, appreciate any help! Goal: To identify the total sum of each company in a specific stage based on a Date criteria. For example: <colgroup><col span="4"></colgroup><tbody> Client Action Date Stage Amount Company A 1/1/2019 1 $100...

Hello, I am wondering if there is a way to do a standard deviation ifs function. I am trying to take the standard deviation from a specific criteria within a spread sheet so for example: one of the criteria I need to fulfill is <=8.5 & >=2.9 & >=18 <=26. So I will need 4 criteria that will need...

I have "inherited" a workbook from a past worker and there is a formula that doesn't give the information required. The formula posted below works but I needs extra criteria. I want it to match against 3 criteria where the existing formula only matches 2 criteria. Can someone tell me the...

Can you do a SumIfs formula where the Criteria is looking at the first 3 characters] I want to Sum Column A where in Column C the first three letters are "DLE". Is this possible?

Dear MrExcel I have to find the value of the latest date, based on 3 criteria: Column A = range criteria 1 (A1:A10) Column B = range criteria 2 (B1:B10) Column C = range criteria 3 (C1:C10) Column D = range of the value/number (D1:D10) Column E = range of the date (E1:E10) A12 = criteria 1...