[已解决]用函数实现数据分列

暗夜男

A1内容是1,22222,3.4,111,4,5,6
每个数用逗号隔开,在b列显示:

1
22222
3
4
111
4
5
6

最佳答案

月排行榜 / 总排行榜

as0810114

2014-2-8 18:51

这样么？

跳转到最佳答案楼层

as0810114

这样么？

暗夜男

as0810114 发表于 2014-2-8 18:51
这样么？

是,但是我发现数据论一大的话就会报错

比如这些,我知道这是有点吹毛求疵了,但是不知道这个函数有木有极限?

还有就是求思路,谢谢

1. 1,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6,22222,3.4,111,4,5,6

复制代码

baksy

as0810114 发表于 2014-2-8 18:51
这样么？

学习了！

tgydslr

暗夜男 发表于 2014-2-8 19:09
是,但是我发现数据论一大的话就会报错

比如这些,我知道这是有点吹毛求疵了,但是不知道这个函数有木有极 ...

大数据的话最好用哪个据说是“除了替人生孩子不会”以外什么都会的“VBA"

暗夜男

tgydslr 发表于 2014-2-8 21:45
大数据的话最好用哪个据说是“除了替人生孩子不会”以外什么都会的“VBA"

其实我也不确定数据有多少,vba可以实现类似公式一样的自动计算不?

暗夜男

as0810114 发表于 2014-2-8 18:51
这样么？

发现个问题,如果我用100个数的话,不会报错,但是54和55之间会多出来一个空白行

1. 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100

复制代码

比如这样

1. ...
   
2. 54
   
3. 
   
4. 55
   
5. ...

复制代码

tgydslr

暗夜男 发表于 2014-2-10 08:02
其实我也不确定数据有多少,vba可以实现类似公式一样的自动计算不?

那是的

yuxirp

vba是无敌的。。。

一片树叶

暗夜男 发表于 2014-2-8 19:09
是,但是我发现数据论一大的话就会报错

比如这些,我知道这是有点吹毛求疵了,但是不知道这个函数有木有极 ...

这个问题解决了没有