criteria lookup

  1. T

    Find one possible match in a matrix (3 criteria, array formula)

    Hi All, The situation that I have is the following: Sheet1: (start and end times of orders) Machine (CELL B1) OrderNumber (CELL E1) StartTime (CELL P1) EndTime (CELL Q1) Machine1 00001 Machine2 00002 Machine3 00003 Machine4 00004 Machine1 00005 Machine2 00006...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...

Watch MrExcel Video

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