Spreadsheet: 128620d1321105434-occurence-of-values-compared-to-specific-previous-ranges-occurence-of-values-compared-to-specific-previous-ranges
Sheet: Sheet1

I am looking to compare each range with a specific number of previous ranges |  |  |  |  |  |  |  |  |  |  |  | Values that appear  exactly 1 time |  | Values that appear exactly 2 times |  | Values that appear exactly  3 |  | Values that appear 4 or |  | Values that do not |  | Values that do not
(see headings) and receive the appropriate result based on occurrence. |  |  |  |  |  |  |  |  |  |  |  | in the previous 12 ranges |  | in the previous 12 ranges |  | times in the previous  12 ranges |  | more times in the previous |  | appear in the previous |  | appear in the previous
The range of the numbers to be checked is 1-120. |  |  |  |  |  |  |  |  |  |  |  | and appear for a 2nd time |  | and appear for a 3rd time |  | and appear for a 4th time |  | 12 ranges and appear again |  | 12 ranges but (see below) |  | 18  ranges
 |  | 2 | 5 | 6 | 8 | 32 | 51 | 101
 |  | 2 | 8 | 15 | 18 | 37 | 48 | 103
 |  | 4 | 7 | 16 | 19 | 26 | 30 | 53
 |  | 8 | 9 | 29 | 40 | 45 | 47 | 52
 |  | 1 | 15 | 21 | 29 | 32 | 42 | 64
 |  | 12 | 13 | 27 | 31 | 38 | 61 | 63
 |  | 4 | 8 | 33 | 38 | 45 | 75 | 88
 |  | 21 | 26 | 33 | 37 | 40 | 67 | 86
Previous |  | 8 | 26 | 27 | 32 | 41 | 47 | 77
19 range |  | 14 | 17 | 19 | 20 | 56 | 60 | 79
and up |  | 3 | 16 | 31 | 38 | 40 | 78 | 89
 |  | 8 | 15 | 25 | 26 | 41 | 57 | 88
 |  | 17 | 23 | 28 | 30 | 35 | 53 | 92
 |  | 2 | 11 | 25 | 26 | 39 | 98 | 103
 |  | 21 | 11 | 13 | 17 | 28 | 60 | 51
 |  | 3 | 7 | 24 | 39 | 41 | 88 | 91
 |  | 7 | 15 | 21 | 34 | 67 | 87 | 90
Previous |  | 7 | 9 | 13 | 20 | 54 | 36 | 83
13 to |  | 4 | 6 | 7 | 35 | 60 | 62 | 98
18 |  | 15 | 23 | 34 | 66 | 68 | 70 | 101
ranges |  | 12 | 16 | 20 | 60 | 65 | 67 | 103
 |  | 4 | 5 | 21 | 60 | 90 | 100 | 119
 |  | 2 | 5 | 6 | 8 | 32 | 92 | 101
 |  | 2 | 8 | 15 | 18 | 37 | 48 | 103
 |  | 4 | 7 | 16 | 19 | 26 | 30 | 53
 |  | 8 | 9 | 29 | 40 | 41 | 60 | 92
Previous |  | 1 | 15 | 21 | 29 | 53 | 42 | 64
12 |  | 12 | 13 | 27 | 31 | 38 | 61 | 63
ranges |  | 4 | 8 | 33 | 38 | 45 | 75 | 88
 |  | 21 | 26 | 33 | 37 | 40 | 53 | 86
 |  | 8 | 26 | 27 | 32 | 41 | 47 | 77
 |  | 14 | 17 | 19 | 20 | 56 | 53 | 79
 |  | 3 | 16 | 31 | 38 | 40 | 78 | 89
 |  | 8 | 15 | 25 | 26 | 41 | 57 | 88
 |  | 17 | 23 | 28 | 30 | 35 | 53 | 92 |  |  |  | 17-30 |  | 92 |  | 53 |  | 0 |  | 23-35 |  | 28
 |  | The example on the right compares C38:I38 with the previous ranges. |  |  |  |  |  |  |  |  |  | Numbers 17 and 30 |  | Number 92 appears  2 times |  | Number 53 appears 3 times |  | There is no number in |  | Numbers 23 and 35 do |  | Number 28 does not
 |  | I do prefer the results being in one cell separated by a dash |  |  |  |  |  |  |  |  |  | appear only once in the |  | in the previous 12 ranges |  | in the previous 12 ranges |  | the previous 12 ranges |  | not appear in the |  | appear in the
 |  | but I don't mind mind if it's easier to be in separate cells |  |  |  |  |  |  |  |  |  | previous 12 ranges |  | and now appears for a 3rd |  | and now appears for a |  | that appeared 4 or more |  | previous 12 ranges |  | previous 18 ranges
 |  |  |  |  |  |  |  |  |  |  |  | (C26:I26 to C37:I37) |  | time in C38:[NAME] |  | 4th time |  | times and appears again in |  | but appear anywhere
 |  |  |  |  |  |  |  |  |  |  |  | and now appear for a |  |  |  |  |  | C38:I38. I would like |  | between the 13th and
 |  |  |  |  |  |  |  |  |  |  |  | 2nd time |  |  |  |  |  | to get a 0  in this case as |  | 18th previous range.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | above instead of a blank
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | cell