criteria lookup

  1. C

    Search criteria and place info from cells in another sheet of cells

    Please help...I have spent hours trying to figure this out but nothing works....yes i am very ignorant about VBA and trying to learn but need this. I need a search button as described below. Any help will be appreciated. Sheet 1 <tbody> A B C D E F 1 123456 2...
  2. X

    Return count of cases that match 2 criteria in same array

    Is there some simple INDEX/MATCH/COUNT equation I can apply or other trick?:confused: For background on my sample: As part of larger database, I have an array going from columns BT3-CK51. Within that array I have columns that specify the same type of data 1 (Method Data in column BT, BU, BY...
  3. B

    data validation based on multiple criteria

    I am searching for a solution This is my problem: I have 6 drop down lists, every drop down list depends on the previous on. The first 2 were no problem, but the others are. The first one is a type of material, the second the same, but based on the first, options are limited. I used an...
  4. D

    COUNTIF criteria, finding "Limit" but exluding "No Limit"

    I have a range of data in column A and B that is pulled from many other sheets in the workbook. The data comes listed out of order, which is fine. I am trying to write a formula in another cell to give me averages for the numbered data in column B. My issue is my data in column A. Examples of...
  5. B

    classifying scores by multiple criteria

    I have ~1000 students in Column A. They have a grade level in Column B (K, 1, 2 ... 11, 12). In Column C there is a test score. I need to classify each student into a LOW, MEDIUM, or HIGH group based on certain cut-points. The difficulty is that the cut-points are different for each of the...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top