求助：来个大神帮我把大于10和小于10的分开，怎么写？

顶帖

有人吗？帮个忙

..............

1,4,8,9,10,12,13,17,18,19,20,22,23,28,32,33,42,43,44,47,48,50
1,6,7,9,10,11,12,14,16,22,25,27,29,30,33,39,41,42,43,44,47,48
7,8,9,10,11,13,16,17,18,22,30,31,32,35,36,37,38,39,40,42,43,45,46,47,50
4,5,6,7,17,19,20,21,24,26,28,29,30,32,36,38,39,40,41,43,47,48
7,9,10,12,14,15,16,19,20,21,27,28,30,33,35,36,37,38,39,40,42,43,44,47,48,49,50
2,7,8,9,10,13,15,18,20,21,22,26,27,28,30,32,36,38,41,43,44,48,49
4,7,8,10,15,16,17,18,21,26,28,35,36,39,40,47,48,49,50
2,4,7,9,12,14,15,18,21,22,25,31,35,36,37,40,43,44,45,49
1,2,3,6,8,11,12,13,15,17,19,24,25,28,29,33,34,35,36,37,40,41,43,45,47,49,50
2,3,9,10,11,13,14,15,18,21,22,24,25,26,27,30,35,36,37,38,39,43,44,45,47,48,50
2,5,8,9,10,11,12,13,20,21,22,32,33,35,40,41,42,43,44,46,49
1,6,7,9,10,12,13,16,17,18,19,20,23,33,36,38,39,40,41,42,44,47,48
1,2,4,11,13,17,18,20,21,22,27,30,32,33,34,35,37,38,39,40,41,43,44,45,46,48,49
3,4,6,7,10,11,14,15,19,20,21,23,35,41,43,44,45,47
1,2,5,7,8,12,13,22,24,44,45
5,7,9,11,12,14,15,19,20,26,29,30,32,33,34,37,38,42,45,47,49
1,3,5,6,7,8,10,12,13,14,18,19,24,28,30,32,34,37,40,42,48
1,8,26,43
2,5,9,10,12,13,15,17,18,19,20,21,24,26,28,30,31,34,35,36,40,41,42,45,49
2,3,6,7,8,11,13,14,15,20,23,25,26,28,31,33,35,36,38,39,40,41,42,45,47,48
5,6,7,9,12,14,15,18,19,22,24,29,33,36,37,39,41,42,43,44,46,50
2,4,14,16,17,22,32,36,49
1,2,6,7,8,9,11,12,14,16,17,18,20,25,28,30,31,34,35,36,38,40,41,45,48,49
1,6,9,11,12,13,14,15,17,18,31,33,34,35,38,41,42,45,46,48,49
3,4,5,6,7,8,9,10,11,12,15,16,17,18,22,28,39,44,46,47
数据

要么先根据逗号拆分单元格，然后再分类。要么自定义公式，用split将单元格内容拆分为数组，然后判断，递归找出结果

Aloha