M函数全集编程频道|福州电脑网

2024年5月10日发(作者：)

此形状表示表切片器。此版本的 Excel 中不支持表切片器。

如果形状是在较早版本的 Excel 中修改的，或者工作簿是使

用 Excel 2007 或更早版本保存的，则不能使用切片器。

序列

268

269

270

271

272

273

274

275

276

277

278

279

280

281

282

283

284

285

286

287

288

289

290

291

292

293

294

295

296

297

298

299

300

301

302

303

304

305

306

307

308

309

310

311

312

313

314

315

316

317

318

319

320

类

List

功能

Accumulate

AllTrue

Alternate

AnyTrue

Average

Buffer

Combine

Contains

ContainsAll

ContainsAny

Count

Covariance

DateTimeZones

DateTimes

Dates

Difference

Distinct

Durations

FindText

First

FirstN

Generate

InsertRange

Intersect

IsDistinct

IsEmpty

Last

LastN

MatchesAll

MatchesAny

Max

MaxN

Median

Min

MinN

Mode

Modes

NonNullCount

Numbers

PositionOf

PositionOfAny

Positions

Product

Random

Range

RemoveFirstN

RemoveItems

RemoveLastN

RemoveMatching

RemoveNulls

RemoveRange

Repeat

ReplaceMatchin

321

322

323

324

325

326

327

328

329

330

331

332

333

334

335

List

ReplaceRange

ReplaceValue

Reverse

Select

Single

SingleOrDefaul

Skip

Sort

StandardDeviat

Sum

Times

Transform

TransformMany

Type

Union

返回的数据描述M函数语法

此形状表示表切片器。Excel 2

any从列表中的项累积汇总值。late(list as list, seed as any, accumulator as func

本中支持表切片器。

logical如果所有表达式均为 e(list as list) as logical

list返回由列表中所有奇数编号ate(list as list, count as number, optional repeatI

如果形状是在较早版本的 Exc

logical如果任意表达式为 true，e(list as list) as logical

或者工作簿是使用 Excel 2007

any返回值的平均值。处理 e(list as list, optional precision as nullable numb

存的，则不能使用切片器。

list缓冲列表。(list as list) as list

list通过合并多个列表来返回一e(lists as list) as list

logical指示列表是否包含值。ns(list as list, value as any, optional equationCriteria as

logical指示一个列表是否包含另一nsAll(list as list, values as list, optional equati

logical指示一个列表是否包含另一nsAny(list as list, values as list, optional equati

number返回列表中的项数。(list as list) as number

nullable 返回两个数值列表之间的协ance(numberList1 as list, numberList2 as list) as n

list给定初始值、计数和增量期meZones(start as datetimezone, count as number, ste

list给定初始值、计数和增量期mes(start as datetime, count as number, step as dur

list给定初始值、计数和增量期(start as date, count as number, step as duration) a

list返回两个给定列表的差。ence(list1 as list, list2 as list, optional equatio

list返回删除了重复项的值列表ct(list as list, optional equationCriteria as any)

list给定初始值、计数和增量 ons(start as duration, count as number, step as dur

list返回包含指定文本的值(包xt(list as list, text as text) as list

any返回列表的第一个值；如果(list as list, optional defaultValue as any) as any

any通过指定要返回的项数或限(list as list, countOrCondition as any) as any

list给定初始值函数、条件函数te(initial as function, condition as function, next

list在给定的索引处将值插入列Range(list as list, index as number, values as list

list返回在输入中找到的列表值ect(lists as list, optional equationCriteria as any

logical指示列表中是否有重复值。inct(list as list, optional equationCriteria as any

logical如果列表为空，则返回 y(list as list) as logical

any返回列表的最后一个值；如(list as list, optional defaultValue as any) as any

any返回列表中的最后一个值。(list as list, optional countOrCondition as any) as

logical如果列表中的所有值均满足sAll(list as list, condition as function) as logica

logical如果任意值满足条件函数，sAny(list as list, condition as function) as logica

any返回最大值，对于空列表则(list as list, optional default as any, optional compa

list返回列表中的最大值。必须(list as list, countOrCondition as any, optional comp

any返回列表中的中位数值。(list as list, optional comparisonCriteria as any)

any返回最小值，对于空列表则(list as list, optional default as any, optional compa

list返回列表中的最小值。可以(list as list, countOrCondition as any, optional comp

any返回列表中出现最多的值。(list as list, optional equationCriteria as any) as a

list返回列表中出现最多的值的(list as list, optional equationCriteria as any) as

number返回列表中的非 null 项数lCount(list as list) as number

list给定初始值、计数和可选的s(start as number, count as number, optional increm

any返回列表中值的偏移量。onOf(list as list, value as any, optional occurrenc

any返回列表中值的第一个偏移onOfAny(list as list, values as list, optional occu

list返回输入的偏移量列表。ons(list as list) as list

nullable 返回列表中的数的乘积。t(numbersList as list, optional precision as nullab

list返回随机数的列表。(count as number, optional seed as nullable number) as list

list返回从偏移量开始的列表的(list as list, offset as number, optional count as n

list返回一个列表，它在列表开FirstN(list as list, optional countOrCondition as a

list从 list1 中删除在列表中Items(list1 as list, list2 as list) as list

list返回一个列表，它从列表末LastN(list as list, optional countOrCondition as an

list删除所有出现的输入值。MatchingItems(list1 as list, list2 as list, optiona

list从指定的列表中删除所有Nulls(list as list) as list

list从指定的位置开始删除指定Range(list as list, index as number, optional count

list返回作为原始列表指定次数(list as list, count as number) as list

list应用 { old, new } 的每个eMatchingItems(list as list, replacements as list,

list从特定位置开始使用替换值eRange(list as list, index as number, count as numb

list在列表中搜索指定的值并替eValue(list as list, oldValue as any, newValue as a

list将列表中的值反向排序。e(list as list) as list

list返回匹配条件的值列表。(list as list, selection as function) as list

any对于长度为 1 的列表返回(list as list) as any

any对于长度为 1 的列表返回OrDefault(list as list, optional default as any) as

list返回一个列表，它在列表开(list as list, optional countOrCondition as any) as l

list根据指定的条件对数据列表(list as list, optional comparisonCriteria as any) as

nullable 返回基于样本估计的标准偏rdDeviation(numbersList as list) as nullable number

any返回列表中的项之和。(list as list, optional precision as nullable number) as any

list给定初始值、计数和增量期(start as time, count as number, step as duration) a

list返回从此列表计算的值的新orm(list as list, transform as function) as list

list返回一个列表，其元素是使ormMany(list as list, collectionTransform as functi

notfunc表示所有列表的类型。notfunc

list返回在输入中找到的列表值(lists as list, optional equationCriteria as any) as

Excel 2013 或更高版

function) as any

onal repeatInterval as nullable number, optional offset as nullable number) as list

的 Excel 中修改的，

l 2007 或更早版本保

ullable number) as any

器。

equationCriteria as any) as logical

ional equationCriteria as any) as logical

s list) as nullable number

number, step as duration) as list

step as duration) as list

duration) as list

onal equationCriteria as any) as list

ria as any) as list

step as duration) as list

any) as any

nction, next as function, optional selector as nullable function) as list

lues as list) as list

teria as any) as list

teria as any) as logical

ny) as any

as any) as any

n) as logical

tional comparisonCriteria as any, optional includeNulls as nullable logical) as any

ptional comparisonCriteria as any, optional includeNulls as nullable logical) as list

ria as any) as any

tional comparisonCriteria as any, optional includeNulls as nullable logical) as any

ptional comparisonCriteria as any, optional includeNulls as nullable logical) as list

as any) as any

as any) as list

ional increment as nullable number) as list

al occurrence as nullable number, optional equationCriteria as any) as any

ptional occurrence as nullable number, optional equationCriteria as any) as any

on as nullable number) as nullable number

able number) as list

l count as nullable number) as list

ndition as any) as list

dition as any) as list

ist, optional equationCriteria as any) as list

tional count as nullable number) as list

ts as list, optional equationCriteria as any) as list

ount as number, replaceWith as list) as list

ewValue as any, replacer as function) as list

t as any) as any

as any) as list

a as any) as list

lable number

ble number) as any

duration) as list

rm as function, resultTransform as function) as list

a as any) as list

M函数全集

发布评论取消回复

最近发表

相关推荐

标签列表

M函数全集

发布评论 取消回复

最近发表

相关推荐

标签列表

发布评论取消回复