mutiple criteria

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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 =...
  6. 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...
  7. 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...
  8. 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
  9. 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()...

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top