multiplecriteria

  1. T

    Select range that are auto-filtered and have certain text value

    Hi, I need some help with filtering and selecting specific cells with multiple criteria. I have a table with a list of fruits and their expiry date. I have tried using VBA to auto-filter the fruit data that are expiring in current month. (xlFilterThisMonth). However, I only want to select data...
  2. W

    Sum Count Ifs

    Hello, How do you write a macro that has an entire range of D3:AD29 equal to the following formula =sum(countifs(range,criteria,range2,criteria2),countifs(range,criteria,range2,criteria2))?? THANK YOU!!!
  3. L

    VBA Loop with multiple conditions on one sheet

    Not sure if this is a duplicate question but couldn't seem to find it anywhere. I have the following sample data: <tbody> A B C D E F G H I 1 EMPLID NAME Dept LOC JOB TITLE EE STS EFFDT HIST EFFDT HIST EE STS 2 123 Doo, Scooby 564 564C Driver L 4/28/2018 3/20/2017 L 3 123 Doo, Scooby...
  4. M

    If a unique value (order number) contains certain values (models) AND IF those models are found in other cells, then return a "yes"?

    Hi All, If this was previously answered, please direct me to that link so I dont have to have you repeat yourselves haha. I honestly dont know what keywords to be searching for. Otherwise, if you can help it would be really appreciated. My company write a bunch of orders (A) which have one or...
  5. L

    Multiple Criteria Ranking without Skipping Numbers when there are Duplicates

    Hi, I am trying to rank a list of orders withing a container based on their shipment date. The difficulty is that within each container there can be multiople orders with the same shipment date. I can use SUMPRODUCT to rank multiple criteria and get the order within each container. The...

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