Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
The example is a simplification of a problemI encountered with "80 trials"
(rows) and "28 times" (columns) where I needed to identify trials that had values that met a specific criteria, but also the pattern of the values that met the criteria. I had a very crude method that took a while. What is the quickest way to determine which of the trials below had 3 or more consequetive values less than or equal to 2? Time 1 Time 2 Time 3 Time 4 Time 5 Time 6 Trial 1 4 3 2 0 1 1 Trial 2 3 1 4 3 0 3 Trial 3 2 4 1 2 1 1 Trial 4 2 5 2 4 3 3 Corrrect answer is: Trial 1 with pattern 2,0,1,1 and Trial 3 with pattern 1,2,1,1 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
count records meeting three criteria | Excel Worksheet Functions | |||
Identifying a specific point on both axis | Charts and Charting in Excel | |||
how do i get "DGET" to take the first data meeting the criteria? | Excel Worksheet Functions | |||
how to sum highest ranking values meeting criteria within a limit? | Excel Discussion (Misc queries) | |||
COUNTIF MEETING TWO CRITERIA eg>5 AND <10.1 | Excel Worksheet Functions |