LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Identifying A Pattern Of Values Meeting Specific Criteria

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
count records meeting three criteria Laura Excel Worksheet Functions 5 December 21st 05 05:47 PM
Identifying a specific point on both axis DrPepper Charts and Charting in Excel 3 November 24th 05 07:04 PM
how do i get "DGET" to take the first data meeting the criteria? Yardarm1 Excel Worksheet Functions 3 June 9th 05 08:21 AM
how to sum highest ranking values meeting criteria within a limit? QuantumPion Excel Discussion (Misc queries) 4 June 7th 05 02:15 PM
COUNTIF MEETING TWO CRITERIA eg>5 AND <10.1 John Higgins Excel Worksheet Functions 2 December 22nd 04 01:19 AM


All times are GMT +1. The time now is 12:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"