I'm trying to generate a random number for each field in column "A" of my spreadsheet, and I have been trying to experiment with the following formula:
=LARGE(ROW($1:$1000)*NOT(COUNTIF($A$1:A4, ROW($1:$1000))), RANDBETWEEN(1,1000-ROW(A4)))
This is giving me the numerical values that I want, but is affecting both Columns "B" and "C" as well. What am I missing??? I just want it to affect column "A".