Do be careful, however, when using the fill handle with RANDARRAY—if you drag the fill handle ... so I'm good to click "OK." Excel then tells you how many duplicates it has removed.

and drag it to where you want to be. Then, click "OK" when Excel reminds you that you're about to replace some data. To duplicate the contents of a cell, row, or column where data is already ...