multi criteria

  1. V

    Vlookup- multiple values

    The cells refer to numbers. I am looking to match numbers on one worksheet to another. Some cells contain the same numbers and it pulls the first one... This is a formula I am working with. The problem is that it picks out the first value that T15 matches to, and disregards the rest of the...
    • vlooku
    • Thread
    • multi criteria vlookup vlookup and if vlookup column reference vlookup if
    • Replies: 5
    • Forum: Excel Questions
  2. M

    VBA Max based on Criteria

    Hi Everyone, I've been using the site for a while but this is my first post, so if there any faux pas' please let me know and I'll make sure it doesn't happen again. Ok, so on to the scenario... I've used VBA to manipulate data for different teams displaying all of their individual open cases...
  3. S

    index for multiple outputs

    Hi, needed some help. I needed to manage the progrees on project and tasks of my team members. In the input sheet, I enter the daily, weekly, monthly and quarterly tasks with the name of person, start and end date and description of the task. In the oupt sheet, I intend to have a sheet for...
  4. F

    sum amount with 2 criteria

    <TABLE style="WIDTH: 268pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=357><COLGROUP><COL style="WIDTH: 87pt; mso-width-source: userset; mso-width-alt: 4242" width=116><COL style="WIDTH: 67pt; mso-width-source: userset; mso-width-alt: 3254" width=89><COL style="WIDTH...
  5. N

    find the next non blank cell above and multiply

    Hi, i hope you can help me with this one i have an excel spread see where some of my columns are blank, however i want to do some multification please see example below: <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p> </o:p>Column A1:A3 has some number, A4 is...
  6. O

    Conditional formatting based on multiple cell criteria

    I've been going at this for days...and I still can't get it right. I'm trying to use conditional formatting so that: Condition 1: When A11 = PM&R 150 Days and D11 is < or = 150 OR When A11 = MLF 240 Days and D11 is < or = 240 The cell turns GREEN Condition 2: When A11 = PM&R 150 Days and...
    • oreyoh
    • Thread
    • conditional format multi criteria text value
    • Replies: 6
    • Forum: Excel Questions
  7. B

    Formula: countif or sumif ?

    I think I need a countif of sumif formula for what I need but am having problems working it out. A formula is required to go into cell B2 to sum those words that relate to the cell in A2, ie A6,7 & 8. And therefore all the other fields would follow suit, ie, relative formulas to fit into the...

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