Excel Macro for Missing Numbers generator
Budget: $10 – $30 USD
Need a simple macro script to show me missing numbers.
Custom range. lets say between 1-80.
Need to add a column of numbers. as an example.
60,20,51,50,26,40,8,33,55,41
71,24,12,75,80,45,63,44,5,54
24,65,19,55,1,59,36,29,51,25
43,21,31,8,46,7,52,29,12,55
9,17,53,64,69,52,43,51,72,22
3,20,26,30,39,42,49,56,61,66
The result should be displayed like this. All the missing numbers separated by a comma on one single line.
2,4,6,10,11,13,14,15,16,18,23,27,28,32,34,35,37,38,47,48,57,58,62,67,68,70,73,74,76,77,78,79
Custom range. lets say between 1-80.
Need to add a column of numbers. as an example.
60,20,51,50,26,40,8,33,55,41
71,24,12,75,80,45,63,44,5,54
24,65,19,55,1,59,36,29,51,25
43,21,31,8,46,7,52,29,12,55
9,17,53,64,69,52,43,51,72,22
3,20,26,30,39,42,49,56,61,66
The result should be displayed like this. All the missing numbers separated by a comma on one single line.
2,4,6,10,11,13,14,15,16,18,23,27,28,32,34,35,37,38,47,48,57,58,62,67,68,70,73,74,76,77,78,79