multiple arguments

  1. V

    Help needed with message box VBA!

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

    Multiple IF Criteria

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

    IFS Formula with multiple conditions. Error: function in the formula causes the result to change each time the spreadsheet is calculated

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

    Summarizing data for multiple locations based on drop down result

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

    VBA copy entire row based on multiple criteria

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

    Using VBA to collect data from work-schedule using multiple criteria

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

    Multiple COUNTIF

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

    Match Cell Values

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

    How to get the corresponding quantity?

    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"...
  10. M

    SUM PRODUCT - Multiple Criteria

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

    Excel table with information

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

    Deleting columns With Multiple Criteria excluding Header row

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

    Adding days to a date range and embedding a formula using COUNTIFS

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

    Help with what route to go with function

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

    Multiple, nested, if, and, or, merge help please.

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

    Multiple If, or, and

    Greetings all - I would like very much to get some assistance with the following please, if anyone has thoughts on it. =IF(BB2="","",IF(AND($AR2="x",$AZ2="L",$AV2="C",J3> $BF2),K3-$BB2,IF(AND($AR2="x",$AZ2="L",$AV2="O",J3> $BF2),K3-$BB2,IF(AND($AR2="x",$AZ2="L",$AV2="B",J3>...
  17. P

    Formula with Multiple argumentsacross two worksheets

    Hi All, I am after some assistance with writing a formula. This is the data I have to work with: Sheet1- <tbody> A B C D E F CIS Key Document Created Date Client Name Planner Name Case ID Task when Document was Created 1111111 8/04/2018 Client 1 Planner 1 23565454 2222222...
  18. P

    If Function with Multiple Conditions to be met first

    Using Excel 2016. Windows 7. I'm stumped and need help. A new real estate investment property was purchased that contains vacant and occupied units. There are two kinds of vacant units: Vacant Penthouse Units (PH) and Vacant Units (or all others that aren’t PH). There are a total of 14 Vacant...
  19. C

    Downtime mesurement

    Hi all, thank you for looking in to this. I have crated a formula to count downtime min from ('Master Data'!X column) when downtime category from B29 equal to range 'Master Data'!W column (see below). =SUMIF('Master Data'!$X$3:$X$4519,"*"&'Data (by date)'!B29&"*",'Master Data'!$W$3:$W$4519)...
  20. B

    Loookup on multiple date range & multiple lines

    Hello - I'm a beginner in Excel so my question may be very simple. I've gone through several threads for the past 45 minutes and cannot find one like this. I believe I may not need a Vlookup or an IF but possibly a INDEX and Match nested formula. I would be eternally grateful if you could assist...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top