criteria

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

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