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
| excel ctrl+g 定位常量 然后删除,可以保留公式
excel ctrl+shfit+方向键
excel 计算时间差 =MOD(B1-A1,1) 单元格格式设置为 "时间"
excel 取整 int(12333/100)*100
excel 自定义万 0"."0,万
=ROUND(C4*D4/10000,2) 万
=INDEX(N:N,RANDBETWEEN(6,40)) 选择范围内随机数
1excel 导出指定列
Sub Export()
Dim Arr, Str1, i
Arr = Range("B1", Range("B1").End(xlDown)).Value
ReDim Str1(1 To UBound(Arr))
For i = 1 To UBound(Arr)
Str1(i) = Arr(i, 1)
Next
Strr = Join(Str1, vbCrLf)
Ph$ = Application.GetSaveAsFilename( _
InitialFileName:="testtest", fileFilter:="*.csv,*.txt")
Open Ph For Output As #1
Print #1, Strr
Close #1
End Sub
0.5~2 1
0.25~0.5 2
2~4 2
3
if(or(u:u>4,u:u<0.25),3,if(and(U:U>=0.5,U:U<=2),1,2))
=B2/SUM($B$2:$B$31) 按F4启用 绝对引用
=IF(ISNUMBER(FIND({"1530618","1890611","1801508","1891583","1330611","1891231","1337520","1533517","1530158"},A:A)),"是","") excel find函数
=SUMIFS(Sheet1!C:C,Sheet1!A:A,"江苏是个好地方",Sheet1!E:E,"扬州",Sheet1!D:D,">=2015/8/1",Sheet1!D:D,"<=2015/8/7")
=SUMIFS(Sheet1!C:C,Sheet1!A:A,"江苏是个好地方",Sheet1!E:E,"扬州",Sheet1!D:D,">=2015/8/1",Sheet1!D:D,"<=2015/8/7")
=SUMIFS(Sheet1!C:C,Sheet1!A:A,"江苏是个好地方",Sheet1!E:E,"扬州",Sheet1!D:D,">=2015/8/1",Sheet1!D:D,"<=2015/8/7")
=SUMIFS(Sheet1!C:C,Sheet1!A:A,"江苏是个好地方",Sheet1!E:E,"扬州",Sheet1!D:D,">=2015/8/1",Sheet1!D:D,"<=2015/8/7")
|
