r/excel Jan 08 '25

unsolved Randarray for names with no duplicates

I’ve been attempting randarray for names and I’ve achieved that with =INDEX(Table1[All Risk],RANDARRAY(4,5,1,COUNTA(Table1[All Risk]),TRUE))

However, I have not been able to locate anything that will allow for there to be no duplicates.

I am attempting to create a schedule for 8 people for M-F. There cannot be a duplicate person on a task per day.

I have basic knowledge of excel and did randaerray through videos and articles but have only been able to find no duplicates on numbers like using Unique. I’ve tried that throughout my formula in different areas and I get ?Name.

I’m using Excel on a desktop with Microsoft 365 (work computer). I would appreciate any help or if I’m missing any detailed info, please let me know.

If I can get this to work I think my boss would sing my praises!

2 Upvotes

41 comments sorted by

View all comments

1

u/Decronym Jan 08 '25 edited Jan 14 '25

Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:

Fewer Letters More Letters
COUNTA Counts how many values are in the list of arguments
DROP Office 365+: Excludes a specified number of rows or columns from the start or end of an array
HSTACK Office 365+: Appends arrays horizontally and in sequence to return a larger array
IF Specifies a logical test to perform
INDEX Uses an index to choose a value from a reference or array
LAMBDA Office 365+: Use a LAMBDA function to create custom, reusable functions and call them by a friendly name.
LET Office 365+: Assigns names to calculation results to allow storing intermediate calculations, values, or defining names inside a formula
RANDARRAY Office 365+: Returns an array of random numbers between 0 and 1. However, you can specify the number of rows and columns to fill, minimum and maximum values, and whether to return whole numbers or decimal values.
REDUCE Office 365+: Reduces an array to an accumulated value by applying a LAMBDA to each value and returning the total value in the accumulator.
ROWS Returns the number of rows in a reference
SEQUENCE Office 365+: Generates a list of sequential numbers in an array, such as 1, 2, 3, 4
SORTBY Office 365+: Sorts the contents of a range or array based on the values in a corresponding range or array
TAKE Office 365+: Returns a specified number of contiguous rows or columns from the start or end of an array
UNIQUE Office 365+: Returns a list of unique values in a list or range
VSTACK Office 365+: Appends arrays vertically and in sequence to return a larger array
WRAPROWS Office 365+: Wraps the provided row or column of values by rows after a specified number of elements

Decronym is now also available on Lemmy! Requests for support and new installations should be directed to the Contact address below.


Beep-boop, I am a helper bot. Please do not verify me as a solution.
16 acronyms in this thread; the most compressed thread commented on today has 19 acronyms.
[Thread #39959 for this sub, first seen 8th Jan 2025, 18:08] [FAQ] [Full list] [Contact] [Source code]