Hi,
I have many lists of number which are entered in the format in a single cell:
1,2,3-6,7,10,11,12,13 all the way to 100, where 8 and 9 are missing
1, 2, 3-9,6,7, 10-55, 67, 99,100
Also there are 14 lines
Line 1: 1,2,5,6,7, 10-66, 100
Line 2: 8,9, 76-79
Line 3: 81,82
I have a cell that says what the count should be, lets call it 100
How can I get back the missing numbers and find any duplicate numbers?
Thanks
JDI
Bookmarks