criteria

Hi! First time poster! I am trying to use a formula field to determine a first occurrence of a contract being signed ( ('Order Items'!$A:$A) result as a "1") or ending (('Order Items'!$B:$B) result as a "-1") per a client name ('Order Items'!$J:$J), per month ('Order Items'!$O:$O), to be...

does any one know a location for the excel function by @Jon von der Heyden which displays AutoFilter criteria (including the date filter) in an Excel sheet

Hi, I've got a spreadsheet with 21 active worksheets. 1 of those is a home page and the other 20 all have data on regarding deliveries for my company. I want to make it so that Excel automatically searches for any deliveries >=TODAY on all the worksheets and copies those rows onto a new sheet...

I'm trying to make a list of codes based on a format of 001 A 001. They should be 001 to 062, A to E, 001 to 012. I need all combinations, so they would be: 001 A 001 001 A 002 to 001 A 012, then up to 001 E 012 Then 001 B 001 to 012, and so on until 001 E 001 to 012 Then 002, A to E, 001 to...

Hello, Sheet2 column a has strings that i want to be saved from sheet1 Sheet1 if column H does NOT contain string that is in sheet2 column A then delete row. So basically sheet2 contains the list of what i want to keep in sheet1, everything else delete. sheet2 ColA needs to be dynamic as the...

We have 100+ customers that we are including in a report; we have to run a query for each customer, and they each have their own criteria that will be used. I’m trying to create a macro that will: Update the criteria used in the query to Like "*Customer 1*" Run the query for the first customer...

I'm shooting for the moon a bit here, but thought I'd ask if this is possible anyway. In the below table, I want to make a list of values appear in column E based on the number in column B (as it's shown now with hard-coded values). For example, if there's a 2 next to QB, then QB would show up...

Hi all, I'm pretty new with Excel, so I would really appreciate any help I can get with this. I have 2 workbooks, one of these is updated with new values every day with rows added onto the existing ones. It looks something like this, with rows going into thousands. I need Excel to pull the...

Help! I am trying to get the Volume for a specific stock on a specific date, using Index & Match. The Volume figure I get is completely wrong. I don't know how to fix this. Date Symbol Daily Volume Symbol Price 11/18/19 A 100,168 A 79.12 What is the Daily Volume for...

I'm trying to average a set of cells based on multiple criteria (hence the AVERAGEIFS), but I want this average to change as more data is added. There may be a very simple fix for this, but I can't figure it out for the life of me. Below is a sample of the table followed by an explanation of...

Is there a good sumif formula or a different formula that would be good to use for a range of criteria and the criteria is all different but specific to what totals I what pulled out of a larger listing? Thanks!

Hi, below is a partial formula. How can I count the number of AND criteria's that are met? (AND(CFW$16=2,CFW48=1),AND(CUI$16=2,CUI48=1),AND(DIU$16=2,DIU48=1)) I just need a 1 for one AND criteria, 2 for two AND criteria's, and 3 for three AND criteria's. Thank you, David

I am trying to use CountIfs and every thread I come across all reference when someone is trying to reference the same cells for different criteria, which I understand why that does not work. What I am trying to do is reference three columns all for different data, but I am getting zeros...

Hi all, I'm trying to get a number from a cell based on the criteria in 2 different cells but in the same column. This has to be pasted in another sheet, which has got the reference number same as one of the above 2 criteria. Please help. Thanks,

Hi. I have a spreadsheet <tbody> D E 1 Question 1 90% 2 Q1 assessment criteria 1 20% 3 Q1 assessment criteria 2 30% 4 Q1 assessment criteria 2 40% </tbody> Under Question 1 there are three things users have to report on their progress with. They type in the % figure and...

Hi I have a table of data with many rows an columns and I'm trying to count the number of records that meet numerous criteria. I've managed to get a lot of it to work but am stuck when it comes to one field that contains one or more partial string elements. My current formula is: -...

First post here and purely asking as I haven't found the answer through informational search. I completely appreciate below might not be the best use of Excel and that there are other tools that would probably be more suitable. I am looking for a MS Excel book for non(strictly)-formula/pivot...

I need to review a list of data and return all of the matches based on 2 criteria and cannot figure out the entire formula. Below is what I have now but it only matches 1 criteria: "CASH IN IMPORT'!$R$5. How on earth do I add a second criteria, which would be column B of sheet '3.INT' matching...

I need help with a complex formula that will search four columns of a table and create a list of dates that match that criteria. I figure it will an array formula and I have found some examples when the criteria is 1 column, but not 4. The Table is "Table1" The column with the date I need in...

Hi I've got a spreadsheet, close to 50,000 rows, for which I have a VBA macro to autofilter on a certain criteria to reduce the number of rows (by deleting) to only have the ones I want left. I now want to have the macro loop through the list to delete rows based on criteria in three colkumns...