mutiple criteria

  1. J

    Two Column match, with 1 result return, displaying horizontally.

    Hello, I've tried small, large, aggregate.. I just can't get it right. My goal is to have a list on a separate sheet, but I tried on the same sheet as the data to see if it can be done first. Look for ID within the list and match, check if that ID matches a criteria in another column (other...
  2. D

    Drop Down List

    Good Day my brave excell'ers! I have a sheet (Sheet2) with the list below [Sheet2] <tbody> a b c 1 Bob obs tech 2 mark nav elec 3 john tac mech </tbody> On [Sheet1] I'd like to have a Drop-Down list in A1, then when a name is selected it populates (B and C) with the relevant...
  3. O

    Lookup multiple values with multiple criteria, fill horizontally by header category

    Hello friends, a long time lurker-first time poster. This place has saved my *** on multiple occasions. Unfortunately, I have now spent days looking for a solution without much luck and felt compelled to ask my first question. The problem at hand is this. I have a list of employees (by ID) and...
  4. R

    Formula Needed for Counting Users within a Specific Date Range

    Hi I have the following data and need to get a count of how many times a user has attended the lab within a specific date range. Can someone help me out with this please? As an example, how can I get the count of 3 if I select the date range of 4/3/2017 to 4/8/2017. I will have the user input...
  5. B

    Help Modify code to allow multiple criteria

    Hi i was wondering if someone can edit this code so I can search by 3 criteria instead of one. Also if 1 or criteria are chosen it will give me those results aswell. This macro works perfectly just missing 2 more criteria. The video below gives me a way to add a second filter but only if both...
  6. J

    Matching 2 Criterias that change in a loop

    Hi All I currently have a piece of code that matches 1 criteria and updates my tracker. I would like now to introduce a second criteria to the match statement. My current code is: Sub UpdateTracker() Dim Mast As Worksheet Dim HOP As Worksheet Set Mast = ThisWorkbook.Worksheets(4) Set HOP =...
  7. T

    Index & Match Function with Multiple References and Multiple Solutions

    Hi, I'm attempting to find a solution to the overcome the problem of having multiple solutions when using an array function with index and match functions. To start, here is a data set example (A1:C7): <style>table { }td { padding-top: 1px; padding-right: 1px; padding-left: 1px...
  8. O

    Sum after matching multiple criteria

    Hello, I am trying to get a total after searching multiple columns and rows in a table. The columns are the categories and the rows are the different and unique data. What method would be most effective to scan down a row for a unique identifier then move on to the next column to search for...
  9. T

    Multiple Criteria

    I'm trying to make a formula that will calculate with two criteria. It keeps giving me an error. =if(A1=90,B1+C1,"0"),(A1>90,B1+D1,"0") Thanks for any assistance, Tmoske
  10. H

    Muliple criteria lookup using VBA

    Gurus, I have been struggling with this problem for several hours... and I am guessing someone has a very basic script that takes care of my problem and is much cleaner. To this point I am able to generate a snippet of what I am trying to create with the following script... Sub LookUp1()...

This Week's Hot Topics

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