| A | |
| 1 |
 =demo.query("select NAME as STATE, ABBR, CAPITAL, POPULATION from STATES")
|
| 2 |
=A1.pselect(left(STATE,1)=="N")
|
| 3 |
=A1.pselect@a(left(STATE,1)=="N")
|
| 4 |
=A1.pmax(POPULATION)
|
| 5 |
=A1.pmin(POPULATION)
|
| 6 |
=A1(5)
|
A2~A6中运算结果如下:
