Pick a random name from a list in Excel
HTML-код
- Опубликовано: 15 окт 2024
- Pick a random name from a list in Excel.
🍐Join my online course on Excel Tables
www.udemy.com/...
🍓Download my free eBook on Excel Macros
eepurl.com/gpT0RD
🍇Check these Books on Excel
xlncad.com/exc...
🍉Read my articles on Excel
xlncad.com/
🍏Playlist for Shorts on Excel
• Short videos on Excel ...
#excelshorts #exceltip #exceltrick
What if I have 500 names..will I select one by one😢?
I need help with this one.
I have an excel sheet that has two columns with the first column that shows 20 different Business Units, and the 2nd column shows how many changes to that corresponding Business unit. Then on the last row of the Business unit is the Grand Total. What I need is to take the Grand Total and divide the Business Units and the changes and assign them randomly to 4 different people, as equally as possible.
This is a daily report, so the Grand Total will change daily.
Please let me know if you need further information.
Thank you!!!
Barbara
Thanks for this video, its a great help. Can you please make a short for selecting a specified number of samples (sample present aa name range) from a specified set of data.
Thanks for your Videos .👌🙏
Or like this: =INDEX(D5:D9,RANDBETWEEN(1,5))
Just an addition:
= INDEX(D5:D9, RANDBETWEEN(1,COUNTA(D5:D9)))
@@omachokomark9028 thank you so much very helpful makes my job so much easier. 😊
@@omachokomark9028 thanks
Very good
Hi, if we have 60.000 values, how we select all the values one by one?
Can I do this in Google sheets? Can I do this f9 trick on excel phone app? Can I do this with a button?
Nice paranses!
Not working
Definitely not working in Excel 2013.
I knew that Elon Musk is so lucky 😁😁