hey guys, i have one quick question. i need to find the missing numbers from 12 rows of 20 numbers.
ie, i have these numbers (only between 1-80) and need to find the *normally* 2 numbers that are not in that list between 1-80. there are 14 rows in this example
1 3 4 8 10 13 14 17 18 28 32 46 48 55 56 57 58 59 64 75
4 12 13 14 17 21 22 23 30 32 35 37 40 44 54 58 61 70 78 80
5 7 10 11 17 20 25 28 30 34 35 36 39 40 49 51 55 60 62 64
3 5 12 18 23 25 41 48 49 50 51 56 58 60 64 66 70 76 78 79
3 11 16 17 19 21 22 25 26 28 29 40 44 47 58 60 63 69 75 78
1 2 6 7 13 16 23 26 35 36 38 39 46 52 53 58 63 70 76 78
7 10 17 20 21 27 29 30 41 44 45 46 47 50 51 55 69 72 73 74
1 3 5 6 7 8 12 16 17 22 28 32 40 47 50 63 65 70 77 80
2 3 6 7 9 11 14 25 30 41 44 48 50 61 63 64 71 78 79 80
5 10 11 16 18 19 20 26 38 41 47 49 51 54 58 66 67 70 73 80
4 10 17 18 23 28 30 31 34 35 37 38 39 42 43 49 51 52 57 63
2 3 14 15 19 20 22 28 29 31 38 41 48 51 52 62 64 69 70 77
11 17 22 28 29 32 33 37 44 46 48 49 51 52 54 58 60 63 66 77
1 2 4 12 25 34 35 36 40 41 42 44 47 49 62 66 69 72 74 78
these numbers wont be the same every time, but in theory after i enter 12 rows there should be only 5/6 numbers left max.
i need a script so that when i copy/paste 12 rows, i can be presented with the numbers not in that field. or even if i have a field of 1-80 displayed, then i copy paste my numbers in the fields below and can somehow highlight which numbers between 1-80 aren't in my pasted fields on the 1-80 field.
hopefully you guys can help me - btw the numbers missing here are 24-68
cheers, brad
ps im using excel starter 10 if that makes a difference
Bookmarks