multiple critera

Hi Everyone, As you can tell by my username, I am very new to Excel VBA. I just started really utilizing it when I first realized that I can record a macro; however, as I continued it, realized what a powerful tool it can be for my work place when utilizing various data sheets. So far, many of...

Hello all, Thank you in advance for any assistance!!! :) I've created a scorecard that tracks performance for one of our patient follow-up teams. I am attempting to track patient satisfaction over time. Successfully generated a result with an AverageIfs function with two criteria...

Hi folks, thanks for all the awesome tips thus far! SUMMARY: I have (1) purchase orders for crayons and (2) a list of several different companies with bagged crayons in varying sized quantities. I'd like to find orders that were made in sequential order that have matching SKU's that are...

Hi all, I have seen many advanced spreadsheets that make use of a single Data sheet, where data is only pasted or imported from some data source and drives the rest of the workbook. I have set up a data sheet that records the type of customer, their status (i.e., recent customer, not-recent...

My objective is to establish a conditional format across the table based on a certain threshold establish for multiple categories. Each category will have a different threshold, which adds another layer of complexity to the issue. Below is an example breaking it down. Feel free to ask what ever...

Hi I have data in columns like this below. A- sellers, B - shops, C- shop addresses <tbody> <tbody> A B C D E F G Ana AA a Ana AA <tbody> * </tbody> Ana BB d Tom AA c Hank CC e Ana AA a Tom CC f Hank FF g Hank AA b Ana AA a </tbody>...

I am trying to lookup a value in a spreadsheet where multiple criteria is involved. Normally I'd approach this task with an index match function, however I am not 100% on how to get the formula started given that in this situation, some of the values being looked up exist in a cell with multiple...

Good morning/afternoon all I'm trying to figure out how to use CountIfs for a monthly Management report strictly using VBA. I can do it using arrays in excel formulas, but the language barrier from Formula to VBA is just beyond me at the present. Here's what I got so far. Dim ws1 As...

Hi all, I need to be able to sum multiple columns based on the column header (to select the columns) but also particular rows based on the first column. Please see the below example: <tbody> Basic Allowance Basic Tax Basic Emp No. Salary Accom Hol Pay Tax Temp Sal 1 5000 1250 850 500...

Hello, This is my first post looking for assistance. I have found the majority of what I need by searching forums and running Google searches, but I have gotten stuck on a project, and I hope you can help. In general, I want a drop down menu of unique item names which fit multiple criteria...

Hi Trying to add multiple columns based on a single criteria using SUMIF, but can't seem to figure it out. I want to add anything in columns E2:K26 based off D2:D26 that is categorized as "Income" <tbody> Date Description/Comments Income/Expense Dues Military Chaplin Fund 50/50 Chalice Fund...

Hello, Been searching high and low for an answer to my question with little luck (hoping i didn't blindly miss it). I have a set of data which changes each week and need to extract a unique list from it, i currently have a formula which works for me, but i now need to adapt it to include...

Hi, I have an issue trying to lookup a text cell when certain criteria are matched. On sheet one I have the Order Date (Column C) and Fleet Number (H) columns On sheet two I have contract start date (P), end date(V), fleet number(I) and maintenance status(Z). I need a formula that will match...

Evening MrExcel Community, Well now it appears it's morning. I'm fairly decent with most things non VBA on excel but the VBA side I don't really know much about. Apparently this is my next area to learn. I have an excel sheet that I update the main info from another database by deleting the...

I have a database which lists daily entries of production data. In my process, material is input as one code, processed, and broken down into several output codes by composition. Within each production run, there are several metrics such as input code, production time, input weight, output...

I need a formula that will lookup a value based on two criteria, one just a cell reference, the other if the period falls within a given range. I was thinking this could be done using a Index>Match formula, but the date range is throwing me off. I'm hoping this can be accomplished without an...

Hey folks! I am trying to enter a formula into a single cell that has a few different arguments - seems easy right. The issue I am running into is that the decision is made based on criteria that fall within a range. For example: The formula would be in cell A2 and would reference D2. If the...

I have a raw data sheet containg cells similiar to below <colgroup><col span="5"><col><col><col span="5"></colgroup><tbody> Date CAPT Tail CBAC ATA Discrepancy Corrective Act Sta Flt MinDLY >30 Min <= 30 Mins 1/1/15 163 3810 16 16 1/1/15 171 3010 11 11 1/1/15 158...

I have been working on a data entry tool for an already existing workbook. I have to use the information available to return a row reference for my tool to work. The problem is there are no column headers. How can I write an index-match or lookup function to accept data from two consecutive...

Hello there, I'm using Excel 2007, and I have been struggling to find the correct conditional formatting for my data. What I have are 4 columns. The first column contains a Job Number(all job numbers are unique), the other three columns contain lot numbers associated with a component of the Job...