Hi Tom,
In column one of the Original Sample Data Numeric Value 101 appears a total
of 3 times. My original text referred to that as 3 consecutive appearances.
Actually, to try and clarify, I should have said the original value and 2
consecutives.
The count that I require is the original Numeric Value and 1 consecutive
appearance: making a total count of 2 appearances, as per Numeric Value 101
in column one of the example immediately below. The Numeric Value should
only be counted if it has a consecutive count of 1, such as Numeric Value 101.
For example:
101 102 107 129 145 370 490 501
101 106 107 128 129 430 470 580
102 129 140 150 350 430 460 470
100 102 129 130 149 330 440 470
NB: In the above example Numeric Value 101 should be counted as it has an
explicit count of 2 appearances which equates to 1 consecutive count.
Numeric Value 101 in column one of the Orignal Sample Data should NOT be
counted. It appears 3 times. I'm looking for a count of an explicit
appearance of 2 times.
Original Sample Data Layout:
101 102 107 129 145 370 490 501
101 106 107 128 129 430 470 580
101 129 140 150 350 430 460 470
100 102 129 130 149 330 440 470
101 108 120 129 200 280 430 535
100 101 170 175 176 280 420 520
121 189 170 202 229 230 420 521
NB: Numeric Value 101 - Col 1 Rows 1,2,3 is a single consecutive count of 2.
Numeric Value 470 - Cols 7,8 Rows 2,3,4 is a single consecutive count of 2.
Expected Results: (Times Numeric Vales appear in groups of 2)
Numeric Value 101 = 1
Numeric Value 107 = 1
Numeric Value 129 = 2
Numeric Value 170 = 1
Numeric Value 430 = 1
Numeric Value 280 = 1
Numeric Value 420 = 1
NB: Numeric Value 101 - Col 1 Rows 1,2,3 is a single consecutive count of 2.
Numeric Value 470 - Cols 7,8 Rows 2,3,4 is a single consecutive count of 2.
How to Count the Consecutive (2x) appearance:
A consecutive value will be in the row below the original value and in any
column; i.e. Col1 Row5 = 101 & Col2 Row6 = 101. This is a count of 1
consecutive for Numeric Value 101.
Cheers,
Sam
Tom Ogilvy wrote:
I have no idea what you want. I am sure my code could be adapted to meet
your conditions but you haven't successfully communicated those to me at
least.
--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200702/1