#multiple criteria

  1. R

    Count unique values with two criteria within date range?

    I have some issues to solve a formula to count unique values in Column A:A from a date (Cell G2/H2) and forward with the two separate criterias (Cell G1/H1) in Column L:L. The purpose is to know when the setpoint of 30 loads is met, which means that it is time for the operator to change the...
  2. L

    Matching shifts to staff availability using partial data.

    Hi, I receive shifts from one source in a table and I have the availability of staff in another source in a table. I would like to return the name of the staff that is available in the column 'Name' in the Shifts Received table. I have tried using INDEX and MATCH but I'm struggling as I need...
    • Luder94
    • Thread
    • #index #match #multiple criteria #partial #vlookup
    • Replies: 0
    • Forum: Excel Questions
  3. F

    Easiest way to have a dropdown based on 2 conditions

    Hello Experts, I am looking for help on below, I am sure this is possible but can’t find a most efficient way to do this. I will capture ID as text in a cell, this can be A_100, A_200, A_300, A_400, A_500 or A_600, (DONE) Based on that ID, I am using VB to paste the days that are associated...
  4. E

    Putting dates on sequential results

    PLEAAAASSEEE HELP ME!!! I am trying to create a route from an excel sheet where it will be placed to a site program then it will auto generate depending on the data provided. I have used basic excel methods but to no success. I need to have the properties scheduled on a monthly basis depending...
    • edongpark
    • Thread
    • #countif #countifs #excel #date #multiple criteria depending excel
    • Replies: 13
    • Forum: Excel Questions
  5. E

    If Or Or Or Statement Then

    Good afternoon, I need to write a formula that does the following: If cell is (#### or #### or any letter combination) then put "MA" if cell is (#### or ####) then put "SC" #### stand for a combination of a few numbers. Haven't been able to figure it out. Thank you!

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
Back
Top