I couldn’t choose this career I couldn’t choose this life, y’all had to choose it for me, y’all chose me, and I take that very seriously. Even if y’all don’t understand what I’m doing sometimes or the music I made sometimes, I just take that responsibility very seriously, you know, to innovate and not imitate, to demonstrate that all limits is fake. And I never felt as much love in one building as I felt tonight. All things are possible through love..
#Excel星球# 计算最大连续值次数的几种常用解法,比如最大连胜次数(最后一种需要O365Beta版)
❶
=MAX(FREQUENCY(ROW(1:16),IF($B$2:$B$16<>"胜",ROW($1:$16)))-1)
❷
=MAX((SUBSTITUTE(CONCAT(B2:B16),REPT("胜",ROW(1:15)),)<>CONCAT(B2:B16))*ROW(1:15))
❸
=MAX(IF(COUNTIF(OFFSET(B1,ROW(1:15),,COLUMN(A:Y)),"<>胜"),,COLUMN(A:Y)))
❹
=MAX(SCAN(0,B2:B16,LAMBDA(x,y,IF(y="胜",x+1,0))))
❶
=MAX(FREQUENCY(ROW(1:16),IF($B$2:$B$16<>"胜",ROW($1:$16)))-1)
❷
=MAX((SUBSTITUTE(CONCAT(B2:B16),REPT("胜",ROW(1:15)),)<>CONCAT(B2:B16))*ROW(1:15))
❸
=MAX(IF(COUNTIF(OFFSET(B1,ROW(1:15),,COLUMN(A:Y)),"<>胜"),,COLUMN(A:Y)))
❹
=MAX(SCAN(0,B2:B16,LAMBDA(x,y,IF(y="胜",x+1,0))))
完成脚本:
一。输入成绩进行等级划分
二。单身男女话聊
三。猜拳游戏
1.和c一样﹨t和n表示空一个字节和换行
标准输出print(":",变量名),
2.想输出前面处理过的数据,print(":"%d %变量,%s%变量2)
3.input函数使用:x=input("娘口三三是:")
4.类型转换和c一样,x=input("夏目是:")int(x)可将字符x转化为整数类型
5.if循环:if xxxx:
yyyy
elif xxxx:
yyyyy
6.注意引号,逗号,括号,冒号都是英文输入。
7.常量定义:x=33
8.比较数值是否相等:if x==33 and y==66:
9.不等于:if x!=33
10.查看数据类型
a="10"
print("输出:"%s %a)
print(type(a))
print("输出:",%d %a)
11.
真True为不为0和none的值
#py# https://t.cn/EiPREja
一。输入成绩进行等级划分
二。单身男女话聊
三。猜拳游戏
1.和c一样﹨t和n表示空一个字节和换行
标准输出print(":",变量名),
2.想输出前面处理过的数据,print(":"%d %变量,%s%变量2)
3.input函数使用:x=input("娘口三三是:")
4.类型转换和c一样,x=input("夏目是:")int(x)可将字符x转化为整数类型
5.if循环:if xxxx:
yyyy
elif xxxx:
yyyyy
6.注意引号,逗号,括号,冒号都是英文输入。
7.常量定义:x=33
8.比较数值是否相等:if x==33 and y==66:
9.不等于:if x!=33
10.查看数据类型
a="10"
print("输出:"%s %a)
print(type(a))
print("输出:",%d %a)
11.
真True为不为0和none的值
#py# https://t.cn/EiPREja
✋热门推荐