How to Pick a Random Name From a List in Excel (Best Way)
Автор: That Answers That
Загружено: 2024-08-17
Просмотров: 1514
How to pick a random name from a list in Excel. In this Excel tutorial, I’ll show you how to create a random name selector in Excel using a simple formula for random name selection. I’ll explain the formula step-by-step. Plus, I’ll share tips on how to set it up so you can add more names without needing to edit the formula each time.
Formula for random name selection in Excel:
=INDEX(A2:A1000, RANDBETWEEN(1, COUNTA(A2:A1000)))
#excel #exceltips #exceltipsandtricks
Timestamps:
00:00 How to Pick a Random Name From a List in Excel
02:44 How to Edit the Formula for Random Name in Excel
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке: