critiria filter

  1. A

    Formula to count how many times adjacent cells in a row fulfil a certain criteria

    Hi, I’m using Excel version 12.1.0 for Mac. I’m having trouble making a formula that will allow me to recognize ‘episodes’ in rows of data. The criteria for an episode is that four or more adjacent cells (adjacent by column) need to have a value of 1,2 or 3. I’d like the formula to count...
  2. pedie

    Please help me change the critiria of filtering :) Thanks

    Sub Macro7() Sheet1.AutoFilter ActiveSheet.Range("$A$2:$T$6277").AutoFilter Field:=10, Criteria1:="Wk Data" ActiveSheet.Range("$A$2:$T$6277").AutoFilter Field:=4, Operator:= _ xlFilterValues, Criteria2:=Array(2, "9/22/2010") End Sub Can the blue area be something like...

Some videos you may like

This Week's Hot Topics