multiple arguments

Hi all, I am trying to do an index match with multiple criteria, but not to return an exact value and I'm having trouble doing it. Can anybody help? The idea is the following: I need to find the payment value (column B) for occurence #55 in IL If there was no "state" column, I would use the...

I am trying to build a spreadsheet that has multiple condition. When I plug in my conditions into conditional formatting, it won't work. 1st condition: I want 3 rows to be filled in blue, with border and vertical lines highlighted, one line no fill/border, then the next 3 rows to be no fill...

I have a sheet that I'm trying to add commas to the final output formatting. If I use just the basic function Rount(Sum(D1:D8),) the output shows the final number formatted correctly. I am also trying to aggregate another row together with this and show a total count of the number of units based...

The formula I am using is not calculating correctly. What am I doing wrong? =IF(C5=0,"",IF(C5>0,SUM(C5-20),IF(A5="*Nov*",A5="*Dec*",A5="*Jan*",A5="*Feb*",SUM(C5-98)))) What I am looking for is, if cell C5=0 then leave blank, if cell C5>0 then subtract 20 from cell C5, and if cell A5 contains...

Hello, I am trying to build a formula that will will be the following results: I need in column D the result of A + B - C if the amount is less than column C If the sum of A + B - C is higher than C then I need as a result the sum of A + B - C So far I get zero using the following formula...

Morning all, Apologies, posting this because I could not find appropriate solutions to my problem. Earlier I obtained this particular code from Dante (which I’m immensely thankful for) which helped in generating a message box (when two conditions are met) for my worksheet: Private Sub...

I got a task in which i have 2 Files One is a Master File containing the names of the clients and the EMI amount with Payment 1 detail And there is Another file containing Daily Collection with payment 2 Detail In Master File there are two column Pay 1 Pay 2(Values Coming From Another File...

I need big-time help here! I have altered the formula so many times and have gotten completely confused and still, get an error "The function in the formula causes the result to change each time the spreadsheet is calculated. The final evaluation step will match the result in the cell, but the...

I've developed a workbook to calculate pricing. Pricing for labor differs based on location - there are 4 locations. A location is chosen and then labor rates auto populate the worksheet(s) based on the chosen location. The location is a drop down list with results 1,2,3,4 in cell M3. (City1...

Hello! I'm working on a macro and i need some help. I need to copy the entire rows from another workbook to my active workbook if a condition is met. The condition is a combination or 3 other conditions conected with OR. I'm giving an example below. Lets say i have the below table and my...

Hi Excel Gurus, For the last few days I'm wrapping my head around an Excel related difficulty and even though I'm pretty used to working with Excel and VBA, I can't figure it out myself. I have a work schedule as shown below, each number in the schedule represents a different type of work to be...

Hi, I'm trying to use multiple COUNTIF to check two sets of criteria. I have a list of ID’s who have a specific fruit for each day of the week. What I need is for the ID and fruit columns to be compared, with the following criteria If duplicate IDs are found and the same fruit on both days it...

Hi all, I have two worksheets in the same workbook The first screenshot is Worksheet A The second screenshot is Worksheet B Question: How to match SIZE PERCENTAGES numbers according to the columns “Line”, “Sub-Line”, “Category”, “Sub-Category”, “Occasion” and “Size Pack”? For...

Hi all, I have two worksheets in the same workbook The first screenshot is Worksheet A The second screenshot is Worksheet B I would like to match the corresponding quantity to the corresponding grade in Worksheet A based on the Columns "Line", "Sub-Line", "Category", "Occasion"...

Hi All, New member :) Struggling with SUMPRODUCT / SUMIF Function. I can do this successfully with 2 criteria / ranges but wont allow me any further. I am wanting to sum up data in a tab/cells (Template!$AL$5:$AX$1115) Based on numerous criteria from many drop down/ data validation lists...

Hi all, Hope You can help me. I have a pretty big table and want some information out of it but don't know how to do it. Hope You guys (and girls) have some ideas. The idea of the table is: <tbody> A B C D E F G H I J Name 1 V V V V V V V V V V Name 2 V V Name 3 V V V V...

Hi, I would like to delete all columns that only contain Blanks, or "n/a". I want a code that deletes based on whether the column contains anything other than a combination of a specific word e.g. "n/a" and/or trimmed Blank cells e.g. "" and/or " ". If it contains something else e.g. other...

Hi I am trying use a COUNTIFS statement as I have a large data set on another worksheet. I am trying to count the number of cells and I have numerous criteria. The one which I can not get to work is: I have a Date Received column and I want to add 56 days to it in the formula combined with...

I have a spreadsheet that I need to calculate a bonus based on the years of service. I have had a formula in the past, but every year it has to be updated because the formula is if the employee has 5-9.9 years of service they get a 2% bonus of their annual salary, if the employee has 10-14.9...

Hello all - I would be very grateful for any help with the following: A very helpful board member, jtakw, helped put together the following...