multiple critera

  1. E

    Pivot Table or Macro to filter data with multiple criteria

    I have a data sheet that I would like to make a pivot table or another sheet off of with a specific customer number and then day of the week. Below is an example of some of the data. Column E is customer numbers. I would like to make a table or sheet using specific numbers from column E and...
  2. T

    Message Box VBA: Multiple Criteria

    Hello - I am trying to figure out how to create a message box that appears based on multiple criteria. I have tried doing research and still can not figure it out. I know minimal VBA, though I am confident it is possible. I currently have a workbook that my project manager enters his crews...
  3. S

    POSITION of nth smallest value in multiple criteria

    I am getting nth smallest value with multiple criteria but couldnt get the position of it. I need postition to lookup other values in the same row of the nth smallest I used the following formulas =IF(AK$2=0,"",IFERROR(SMALL(IF($K$4:$K$20=AK$2,$I$4:$I$20),$U$4:$U$20),"")) No issue with this...
  4. A

    Need To Delete Rows Based On Multiple Criteria

    Hi, I'm knew to this and would appreciate any help provided. I read somewhere that there is a limit to the number of terms that one macro could handle. I need a VBA script to delete multiple rows in column “A” based on if the cell has (ANY) reference of over 150 terms. For example, if I want...
  5. E

    Return unique values based on multiple conditions and sorted by date

    Hello, I have data similar to whats shown in the "Orig Data' table. I would like to pull unique Names only, based on two criteria (Start Date <= today AND End Date >= today. I would also like the data sorted (oldest to newest) based on the Name's corresponding End Date . My goal is to have a...
  6. N

    VBA Macro - Auto Filter Multiple Criteria

    Hi, I'm struggling with the below VBA. I have data In cells A6:S1176 and headings in cells A5:S5. I want to filter column A based on the value in B1. I then at the same time want to always filter out anything minus or below 0 in column G. When I run this macro though I get this error message...
  7. S

    Return value from a table based upon multiple criteria

    Hello, I have a spreadsheet with the following 4 columns – Group,Type, Day Rate, Night Rate. Each row ofeach column has a drop down selection list. Based upon the selections made, I want the spreadsheet to populate theappropriate Day Rate and Night Rate. Data regarding the rates is in a...
  8. S

    How can i auto filter on 2 columns with Multiple criteria and then copy columns to different sheet

    Hi Team, I am using below macro to auto filter on col D and Col F on worksheet "confirms" with below criterias and then trying to copy col P and Col S filtered data to another worksheet names "Non=Cash Trades". the below code is autofiltering only col D with "N" and Col F with "COD" not "F/D"...
  9. S

    Autofilter Multiple Criteria, Copy and Paste Visible cells only excluding header

    Requesting help with setting up a macro to autofilter multiple criteria, copying visible data only, and selecting and pasting sections of the data at a time into another worksheet in the file. Here is a previous post that works for single criteria...
  10. S

    Index Match in VBA function

    Hi, I'm trying to develop a Index/Match function in VBA with multiple criteria (using the "&" as in an excel function) - but it doesn't work. Does anybody know what I'm doing wrong? Function prove(X As Range, Y As Range, Z As Range) A = Application.WorksheetFunction.Index(X...
  11. B

    COUNTIFS and SUMIFs statement - contains specific text OR specific text - without an array?

    hi, two questions: wondering what the most efficient way to write these would be - without just combining multiple countif functions on top of one another to do this without using an array? 1: count the number of times any of the following appears in column R - ABS, BND, or FUND; while...
  12. H

    Match all values within a filtered range based on multiple criteria

    Hello All, I've started playing with VBA some days ago, thus I'm new with Excel coding. Below is a simplified version of the sheet I want to extrapolate the data from (sheet name "Data"): <tbody> Customer Platform Program Motor Type A 1 pr1 aa A 1 pr2 aa A 1 pr3 aa A 1 pr4 cc A 1...
  13. V

    Create list of data meeting multiple criteria

    I have two issues that I am looking for help with. The first, is to create a dynamic list of results for items matching "Horse" in column J on Sheet 2!, "Ball" in column I on Sheet 2!, and that do not contain the word dog in column A on Sheet 2! The second, is that while I have calculated the...
  14. P

    Unique record count with multiple criteria

    Hi This is me first time posting on this forum, so hoping someone can answer. I have data in the below sample format. I am trying to get a record count when the values in column 1(Week) and column2 (Name) match together. For example, User1 has three entries for 7/14/2018. So in column3, I...
  15. H

    IF Function that has multiple criteria.

    Hi there, I am trying to construct an IF Function for the following problem: Data: 5 collums of data (A,B,C,D,E) and 33 participants. Conditions: define person as 'high risk' if either '3 out of 4 values (A,B,C,D) are smaller than 10' OR if '2 out of 4 values (A,B,C,D) are smaller than...
  16. C

    How to add additional Criteria to Ron de Bruin's "Mail a row or rows to each person in a range" code?

    I toyed with this all day yesterday. Been working away at it all morning and still can't whip it. I think it will be relatively easy for someone with some VBA experience... I'm just not quite there. So, basically, Ron de Bruin's code from this page works great. Does just what it's supposed to...
  17. R

    Create a unique list of values based on criteria in column where column meets criteria

    I need a formula to return a unique list of values in (A3:A6) of values from (D2:D6) that are in the column (E:H) that match the criteria in (B1) and have an "x" in Rows (2:6). Need column searched to change based on value in (B1). Thank you:) <tbody> A B C D E F G H 1 Criteria...
  18. L

    2nd, 3rd, ... nth most common text within a date range

    I have searched all over for a solution to this and I am beyond flummoxed. Don't let me down... My data is in two columns (Diagnosis and Date) and I need to know the 1st - 3rd most common Diagnoses within a particular date range. Diagnosis Date Autism 1/31/18 Down's Syn 12/5/17...
  19. M

    Sumif / Sumproduct - Help :)

    Hi Everyone - I'm looking to create a sum formula to capture multiple criteria and I am open for suggestions. <tbody> Jan Feb Mar List: List: Car 1 1 2 Car Jan House 2 2 1 Airplane Mar Airplane 2 3 3 Boat Boat 5 5 3 Formula: XXXX </tbody>...
  20. E

    Formula for Matching Multiple Criteria... NEED HELP

    Hi all, Below is a sample of a table on a worksheet (we'll call this one PRODUCTS): <tbody> ITEM DESCRIPTION LIST PRICE COST PRICE UNIT ANGLE BAR 1/2" X 3" X 3" $0.62 $0.52 LB ANGLE BAR 1/2" X 4" X 4" $0.31 $0.26 LB ANGLE BAR 1/4" X 1 1/2" X 1 1/2" $72.67 $60.56 CWT ANGLE BAR 1/4" X...

Some videos you may like

This Week's Hot Topics

  • SUMPRODUCT active link formula
    Hi guys i have sumproduct formula for counting two range of number, i want count active cells of formula that linked to another sheet...
  • Block certain cells in condition met in cell A
    Hi there, trying to figure out step by step how to build macros and learn more. Now given that my other code was a mess, I figured I would...
    Hi, Below formula works well, =(INDEX('PRICE LIST'!$C$7368:$C$7679,MATCH(1,(WORKSHEET!O28='PRICE LIST'!$A$7368:$A$7679)*(WORKSHEET!P28='PRICE...
  • Match data from 3 columns to return data from the correct 4th column
    Hi there! I'm trying to have a cell auto-populate the data in a cell based on the data entered in 3 other cells. I've pasted a copy of the...
  • VLookup
    Hi everyone, I need to find the value from one sheet to another. So in Sheet A Field N5 I have a value (Spark) I want to find Spark on the Sheet...
  • Defining a range
    Private Sub Worksheet_Calculate() Dim Xrg As Range Set Xrg = Range("K1") If Not Intersect(Xrg, Range("K1")) Is Nothing Then MsgBox...

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
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 "".
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