效率職人 on Instagram: "EXCEL是隨機分組小幫手 📝小抄： =WRAPROWS(SORTBY(範圍,RANDARRAY(人數)),分幾組) 💡公式說明： ▮RANDARRAY(人數)：隨機產生15個亂數 ▮SORTBY(姓名, 亂數)：依照亂數排序，等於把姓名順序打亂 ▮WRAPROWS(..., 分幾組)：將打亂的姓名進行分組 🔥完成： 只要按F4，就會自動隨機分組 ⚠️此公式365限定 ----------------------------- 如果不是版本365呢? 完整教學(含通用版教學) https://vocus.cc/article/696eee4efd897800012a3604 或者留言「分組」我把完整的教學傳給你 ------------------------------ 相關問題加入LINE社群，主頁連結加入 記得按讚蒐藏要用時才不會找不到唷 學習更多EXCEL不為人知的小技巧點選這個標籤 #效率職人意想不到的函數應用 #效率職人 #excel #分組 #函數"
0:53
效率職人 on Instagram: "EXCEL是隨機分組小幫手 📝小抄： =WRAPRO…
14.3K views1 month ago
Instagramefficiency_person
Statistics OER - Section 6-1-a Central Limit Theorem for Sample Means
36:14
Statistics OER - Section 6-1-a Central Limit Theorem for Sample …
1 week ago
YouTubeSophia Georgiakaki
Excel“造物主”RAND系列随机函数，居然这么强？
5:45
Excel“造物主”RAND系列随机函数，居然这么强？
502 views1 month ago
bilibili咸了鱼Office
Plane spotting at Schiphol Airport | Beautiful landings & take off's!
23:51
Plane spotting at Schiphol Airport | Beautiful landings & take off's!
540.3K viewsOct 13, 2013
YouTubeBa Co
Patito Feo - Capitulo 132 - 1° Temporada
40:42
Patito Feo - Capitulo 132 - 1° Temporada
1.1M viewsJan 5, 2013
YouTubeJosefa Belen Gutierrez
操作类函数2_RANDARRAY（返回随机数组）
4:12
操作类函数2_RANDARRAY（返回随机数组）
171 viewsApr 28, 2024
bilibili不好了出大事了
130 BPM 1/4 Wood Metronome HD
10:01
130 BPM 1/4 Wood Metronome HD
26.5K viewsOct 22, 2014
YouTubeBeautiful Metronome
7:43
Excel数组函数（二）使用randarray sortby函数制作舒尔特方格
93 viewsSep 20, 2023
bilibili不好了出大事了
3:44
Sorriso Maroto - 1 Metro e 65 (Sorriso Eu Gosto Ao Vivo) [Áudi…
15.7M viewsDec 3, 2014
YouTubeSorriso Maroto
4:12
Excel动态数组函数RANDARRAY
2.1K viewsSep 26, 2023
bilibiliLizongzhang
2:59
“Excel Shortcut: Make Random Arrays FAST!”
119 views2 months ago
YouTubeBook Worm
0:24
WAS THAT THE BITE OF 87?!?
679.3K viewsFeb 21, 2022
YouTube𝙡𝙪𝙫𝙠𝙞♡
1:40
RANDARRAY返回一组随机数
418 viewsMay 10, 2023
bilibili李苹办公软件365
5:57
Day153Excel表格随机数组生成函数Randarray入门
293 viewsFeb 20, 2022
bilibiliExcel数据处理大表哥
1:00
Excel Random Sample From a List - #shorts - Episode S0030
11.7K viewsApr 13, 2023
YouTubeMrExcel.com
0:21
EXCEL技巧：生成随机数
117 viewsNov 29, 2023
bilibili鹰之泪工作室
2:39
excel生成特定区间的随机数rand、randbetween和randarray函数
15.4K viewsSep 26, 2023
bilibili研渣渣的学习笔记
0:51
Excel Hack: Instantly Pick Random Rows! 🔥 #ExcelTips #ExcelHack #E…
171 views3 months ago
YouTubeData by Jundi
0:06
Numpy Random Examples #python #numpy #machinelearning #datas…
1.7K views5 months ago
YouTubeTech - jroshan
15:12
Metropolis Algorithm in Excel
208 viewsMay 12, 2024
YouTubealicia.science
12:17
Office-365 Part-14 Detect Language, Translate, Randarray, Read data fr…
159 views5 months ago
YouTubeNeeraj Kaushik
15:17
A Complete Guide to the RANDARRAY Function
4 views4 months ago
YouTubeAethenos
1:11
每日函数：数学类；Rand、RandBetween、RandArray；随机 …
180 viewsAug 24, 2023
bilibili讲师王子宁
4:48
Cum Folosești Funcția RANDARRAY în Excel | Generare de Numere Ale…
194 viewsOct 22, 2024
YouTubeEXCELentii
0:56
Random Grouping in Excel Made Easy (WRAPROWS) #learnexcel #…
316 views2 months ago
YouTubeAli Burhanudin H
14:51
Use Monte Carlo and the Excel RANDARRAY function to estimate pi
1.6K viewsMar 1, 2021
YouTubeDavid Johnk
1:33
Understanding rand()%(a+ 1): How to Generate Random Numbers Bet…
11 months ago
YouTubevlogize
7:46
Perbedaan Fungsi RAND, RANDBETWEEN dan RANDARRAY
580 viewsDec 10, 2022
YouTubeAhsani_VidsT
4:26
Функция СЛМАССИВ замена СЛЧИС и СЛУЧМЕЖДУ?
585 viewsSep 7, 2019
YouTubemsofficeprowork
20:31
Build a deck of cards in Google Sheets with MAKEARRAY
2.3K viewsSep 19, 2023
YouTubeYagisanatode -Scott-
See more videos
Static thumbnail place holder