three criteria

  1. T

    Filter Function with three criteria based on "AND"

    Good day I’m looking for help with the FILTER function. The aim is to filter data into a separate worksheet based on three criteria 1) All blank cells in a column, 2) Dates more than or equal to a certain date (based on a captured date in another cell), and 3) Dates less than or equal to a...
  2. H

    Formula needed to track the number of times each customer picked up 4 or more parcels on the preferred pick up day within a given time frame

    Hi Everyone, We have a daily log of the number of parcels picked up by our customers. The number of parcels to be picked up ranges from 0 to a maximum of 5 per day. Customers are each assigned a pick-up day (Column C) if they are picking up 4 or more parcels. Row 1 shows the date the parcels...
  3. L

    AVERAGE/MAX/MIN/MEDIAN meet 3 Criteria (2 criteria in Row, 1 in Column)

    The formula I am looking to build will be used to calculate the average, max, min, and median. For this post, I will stick to just calculating the average (but it would be extremely helpful if in the formula I could replace the AVERAGE function with MIN, MAX, or MEDIAN). I have a table of data...
  4. S

    Help.. Count of records with "Yes" value from a range where date reange on same page is between 2 cell dates on another page.+

    Hi, I'm trying to count the following: 'Master Log'! g13:fox13 = "Yes" and 'Master Log'! G6:Fox6 >= Analysis!A8 and 'Master Log'! G6:Fox6 <= Analysis!C8 (These are all date fields) What should the correct formula format be for getting the count? Let me know if more information is needed...

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
Back
Top