
- UID
- 222281
- 帖子
- 261
- 主题
- 59
- 注册时间
- 2011-7-2
- 最后登录
- 2014-6-28
|
I just saw this query,
Actually you can use function ‘large’
so you insert one column at the left and 51 (1/10 of the maximum rows +1) rows at the top of your data
A2:A51 = 1 to 50
b1 = =COUNT(B52:B7001),
b2 = =IF($A2 |
|