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

Some videos you may like

This Week's Hot Topics