Hoping for a formula or UDF to do this (UDF preferred).
Please see file 'Others_Numbers.xlsx'
**Note** I am asking for a somewhat similar result here but it's much more complex and am asking for actual missing pairs.
This request is different.
http://www.mrexcel.com/forum/excel-questions/942440-sort-groups-4-numbers-5.html
From Post #44 but it has stalled. If anybody would like to try for a solution please do.
Please see file 'Others_Numbers.xlsx'
**Note** I am asking for a somewhat similar result here but it's much more complex and am asking for actual missing pairs.
This request is different.
http://www.mrexcel.com/forum/excel-questions/942440-sort-groups-4-numbers-5.html
From Post #44 but it has stalled. If anybody would like to try for a solution please do.