【201502函初】必交练习三(已开贴)

橙子e叮咚

C04:橙子e叮咚
第一题

1. =TEXT(RANDBETWEEN(1,425631),"yyyymmdd")&TEXT(RAND(),"hhmmss")&TEXT(RANDBETWEEN(1,100),"000")

复制代码

第二题

1. 不会

复制代码

第三题

1. =IF(ROW()=21,"",IF(ISERROR(FIND(1,RANK(A16,$A$16:$A$34,0),1)),"",RANK(A16,$A$16:$A$34,0)))

复制代码

today0427

A05:TODAY0427
第一题：

1. =TEXT(RANDBETWEEN(1,7^8)/100,"yyyymmddhhmmss")&TEXT(RANDBETWEEN(1,100),"000")

复制代码

第二题：

1. =IF(COLUMN(C6)=3,LEFT($A6,8),IF(LEN(IFERROR(MID($A6,FIND(" ",$A6)+1,11),MID($A6,FIND("/",$A6)+1,11)))<11,"",IFERROR(MID($A6,FIND(" ",$A6)+1,11),MID($A6,FIND("/",$A6)+1,11))))

复制代码

第三题：

1. =IF(--LEFT(RANK(A16,$A$16:$A$34),1)=1,RANK(A16,$A$16:$A$34),"")

复制代码

vicky4896

C03：vicky4896
1.

1. =TEXT(RANDBETWEEN(1,2958465)+TEXT(NOW(),"h:mm:ss")-RAND(),"emdhmmss")&TEXT(RANDBETWEEN(1,100),"000")

复制代码

2.

1. =CHOOSE(COLUMN(A1),IF(ISNUMBER(--LEFT($A6,8)),LEFT($A6,8),""),IF(ISNUMBER(--RIGHT($A6,11)),RIGHT($A6,11),""))

复制代码

3.

1. =IF(COUNT(SEARCH(1,RANK(A16,$A$16:$A$34))),RANK(A16,$A$16:$A$34),"")

复制代码

{:091:}

ddhhyy16

1. =TEXT(RANDBETWEEN(0,99)+RAND(),"yyyy-mm-dd hh:mm:ss")
   
2. =IFERROR(CHOOSE(COLUMN(A1),--LEFT($A6,8),--RIGHT($A6,11)),"")
   
3. =IF(ISERROR(FIND(1,RANK(A16,$A$16:$A$34,0))),"",RANK(A16,$A$16:$A$34,0))

复制代码

H明悠

C08：H明悠
第一题

1. =TEXT(RAND()*10^5,"YYYYMMDDHHMMSS")&TEXT(RAND()*100,"000")

复制代码

第二题

1. =IFERROR(CHOOSE(COLUMN(A1),--LEFT($$$$$$$$$$$$$$$$A6,8),--RIGHT($$$$$$$$$$$$$$$$A6,11)),"")

复制代码

第三题 不会

520陈莉莉

C10：520陈莉莉

1. 第三题：不会

复制代码

1. 第一题：=TEXT(RANDBETWEEN(0,NOW()),"yyyymmdd")&TEXT(RAND()*(0.999999999-0)+0,"HHMMSS")&TEXT(RANDBETWEEN(1,100),"000")

复制代码

1. 第二题：=IF(ISERROR(LEFT(SUBSTITUTE(SUBSTITUTE(LEFT(A6,FIND("/",A6)-1),"*","/"),"-","/"),8)),"",LEFT(SUBSTITUTE(SUBSTITUTE(LEFT(A6,FIND("/",A6)-1),"*","/"),"-","/"),8))

复制代码

1. 第二题：=IF(LEN(MID(SUBSTITUTE(A6," ","/"),FIND("/",SUBSTITUTE(A6," ","/"))+1,99))<11,"",MID(SUBSTITUTE(A6," ","/"),FIND("/",SUBSTITUTE(A6," ","/"))+1,99))

复制代码

绵花糖

{:271:}A组长：绵花糖

1. 第一题
   
2. =SUBSTITUTE(TEXT(NOW(),"yyyy:m:dh:mm:ss")&RANDBETWEEN(100,999),":",)
   
3. 第二题
   
4. =CHOOSE(COLUMN(A1),IF(ISERROR(FIND("/",$A6)),"",LEFT(A6,8)),IFERROR(RIGHT($A6,11)*1,""))
   
5. 第三题
   
6. =IF(ISERROR(FIND(1,RANK(A16,$A$16:$A$34,0))),"",RANK(A16,$A$16:$A$34,0))

复制代码

rlzcjrrmy

[201502函初]
第一题：

1. =RANDBETWEEN(1000,2000)&TEXT(RANDBETWEEN(1,12),"00")&TEXT(RANDBETWEEN(1,31),"00")&TEXT(RANDBETWEEN(1,24),"00")&TEXT(RANDBETWEEN(1,60),"00"&TEXT(RANDBETWEEN(1,60),"00"))&TEXT(RANDBETWEEN(1,100),"000")

复制代码

第二题：

1. =IF(IFERROR(FIND("/",IF(AND(COLUMN()=3,LEN($A6)<FIND(CHAR(32),A6&CHAR(32))),LEFT($A6,8),IF(COLUMN()=4,RIGHT($A6,11),""))),IF(AND(COLUMN()=3,LEN($A6)<FIND(CHAR(32),A6&CHAR(32))),LEFT($A6,8),IF(COLUMN()=4,RIGHT($A6,11),"")))<100,"",IFERROR(FIND("/",IF(AND(COLUMN()=3,LEN($A6)<FIND(CHAR(32),A6&CHAR(32))),LEFT($A6,8),IF(COLUMN()=4,RIGHT($A6,11),""))),IF(AND(COLUMN()=3,LEN($A6)<FIND(CHAR(32),A6&CHAR(32))),LEFT($A6,8),IF(COLUMN()=4,RIGHT($A6,11),""))))

复制代码

第三题：

1. =IF(AND(RANK(A16,$A$16:$A$34)>1,RANK(A16,$A$16:$A$34)<10),"",RANK(A16,$A$16:$A$34))

复制代码

1. 
   

复制代码