Random Name Finding

Date 06 December 2016
Author ExcelDepo
Category Power Query
Type XLSX
Access Free

An Excel file that teaches how to perform Creating Personnel Records with UserForm operation.

Excel Solution: Random Name Finding

The name list is defined as a table. An index is generated using RANDOM. The INDEX function returns a value. A check is added based on the repetition preference. Selected records are marked. A re-draw is triggered with a button.

Hope it is useful.

ExcelDepo Archive
9,000+ ready Excel templates. One-time payment, instant download.
₺599 ₺299
Get Archive →
Previous File Create a pivot table by date range
Next File Calculating Reinsurance Commissions
Günün Excel İpucu · Formül

Sayfa adını formülle hücreye çekme

Aktif sayfanın adını dinamik almak için: =PARÇAAL(HÜCRE("filename";A1); MBUL("]"; HÜCRE("filename";A1))+1; 31). Sayfa kopyalandığında veya yeniden adlandırıldığında değer otomatik güncellenir. Rapor başlığı, dosya adı kontrolü için pratik. Microsoft 365'te kısalı: =SAYFA.ADI() (TR Excel'de henüz yok, EN'de SHEETNAME).
PARÇAAL fonksiyonunu detaylı incele →

You might also like

Archive + HR Combo
Archive + Bundle together at a discounted price. Best value.
₺699 ₺1.498
Get Combo →
ExcelDepo Archive
9,000+ ready Excel templates. One-time payment, instant download.
₺299 ₺599
Get Archive →
HR Bundle
25 professional HR templates. Payroll, leave, performance — all ready.
₺599 ₺899
Get Bundle →

Related Files

Business

Creating an Exterior Doorbell Nameplate

99
1,741
0.0
Business

Finding Out the Labor Cost in 2026

85
877
0.0
Charts

Finding the Average Salary by Departments

25
872
0.0
Charts

UEFA Euro 2024 Tournament Schedule

3
652
0.0
Engineering

Finding the Corresponding Digit for Matching Names

0
627
0.0
Macros

Finding RGB Values of Colors

0
568
0.0