Hello
I have a group of say 100 random integer numbers ranging from 0 to 40 (inclusive). (The numbers can repeat themselves)
I want Xcel to tell me
How many integers appeared consecutively as even numbers and odd numbers.
Also how many numbers appeared consecutively with a value as less than 20 and how many with a value greater than 20
Let the ZERO be both ODD/EVEN and have a value greater/less than 20 in any sequence.
Say numbers are:
5
23
39
2
0
2
2
0
15
19
33
31
33
and so on
In the example above :
2 and 3 integers appeared consecutively that were above the value of 20. That is the 23, 39 and the 33, 31, 33
3 and 6 integers appeared consecutively that were ODD. That is the 5, 23, 39 and the 0, 15, 19, 33, 31, 33
5 integers appeared consecutively that were EVEN. That is the 2, 0, 2, 2, 0
Thank you for your help
PS I haven't got a clue about how to use EXCEL really so if you can help me with which cell to insert which formula that would be great
Bookmarks