Generating random lists of numbers in Excel ... return duplicates depends on the range you specify—the larger the range, the less likely the function is to return repeated numbers. There are ...

Excel comes with a built-in tool that makes ... it was the second row that included "blue" in Column B. Now there are no duplicate shapes or colors. "Remove Duplicates" is a powerful tool.