X
XLSUSER
I WANT TO ADD TWO RANDOM CHARACTERS TO ROWS IN A TABLE THAT ARE UNIQUE SUCH
AS AB, AC, AD, AF, ETC..
CAN THIS BE DONE IN EXCEL?
AS AB, AC, AD, AF, ETC..
CAN THIS BE DONE IN EXCEL?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
Max
Assuming duplicates are not an issue,
Try: ="A"&CHAR(RANDBETWEEN(65,90))
Copy across or down as required
As randbetween is used, ensure that the Analysis Toolpak is installed and
activated. Check the "Analysis Toolpak" box (via Tools > Add-Ins)
Chip Pearson's page has details on the ATP at:
http://www.cpearson.com/excel/ATP.htm
Try: ="A"&CHAR(RANDBETWEEN(65,90))
Copy across or down as required
As randbetween is used, ensure that the Analysis Toolpak is installed and
activated. Check the "Analysis Toolpak" box (via Tools > Add-Ins)
Chip Pearson's page has details on the ATP at:
http://www.cpearson.com/excel/ATP.htm
M
Max
If there should be no duplicates generated
(i.e. all 26 random possibles: AA to AZ must be unique)
here's one set-up to try
Using say, the rightmost 2 columns, IU & IV
Put in IU1: =CHAR(ROW()+64)
Put in IV1: =RAND()
Select IU1:IV1, copy down to IV26
Then within the same sheet:
To generate down a column
we could put in say A1:
="A"&INDEX(IU:IU,RANK(IV1,$IV$1:$IV$26))
and copy A1 down as many rows as required (up to the max of 26 rows)
Or, to generate across any row, we could put in say, A28:
="A"&INDEX($IU:$IU,RANK(OFFSET($IV$1,COLUMN(A1)-1,),$IV$1:$IV$26)
and copy A28 across as many cols as required (up to the max of 26 cols)
Pressing F9 will regenerate afresh
(i.e. all 26 random possibles: AA to AZ must be unique)
here's one set-up to try
Using say, the rightmost 2 columns, IU & IV
Put in IU1: =CHAR(ROW()+64)
Put in IV1: =RAND()
Select IU1:IV1, copy down to IV26
Then within the same sheet:
To generate down a column
we could put in say A1:
="A"&INDEX(IU:IU,RANK(IV1,$IV$1:$IV$26))
and copy A1 down as many rows as required (up to the max of 26 rows)
Or, to generate across any row, we could put in say, A28:
="A"&INDEX($IU:$IU,RANK(OFFSET($IV$1,COLUMN(A1)-1,),$IV$1:$IV$26)
and copy A28 across as many cols as required (up to the max of 26 cols)
Pressing F9 will regenerate afresh
M
Max
If there should be no duplicates generated
(i.e. all 26 random possibles: AA to AZ must be unique)
here's one set-up to try
Using say, the rightmost 2 columns, IU & IV
Put in IU1: =CHAR(ROW()+64)
Put in IV1: =RAND()
Select IU1:IV1, copy down to IV26
Then within the same sheet:
To generate down a column
we could put in say A1:
="A"&INDEX(IU:IU,RANK(IV1,$IV$1:$IV$26))
and copy A1 down as many rows as required (up to the max of 26 rows)
Or, to generate across any row, we could put in say, A28:
="A"&INDEX($IU:$IU,RANK(OFFSET($IV$1,COLUMN(A1)-1,),$IV$1:$IV$26)
and copy A28 across as many cols as required (up to the max of 26 cols)
Pressing F9 will regenerate afresh
(i.e. all 26 random possibles: AA to AZ must be unique)
here's one set-up to try
Using say, the rightmost 2 columns, IU & IV
Put in IU1: =CHAR(ROW()+64)
Put in IV1: =RAND()
Select IU1:IV1, copy down to IV26
Then within the same sheet:
To generate down a column
we could put in say A1:
="A"&INDEX(IU:IU,RANK(IV1,$IV$1:$IV$26))
and copy A1 down as many rows as required (up to the max of 26 rows)
Or, to generate across any row, we could put in say, A28:
="A"&INDEX($IU:$IU,RANK(OFFSET($IV$1,COLUMN(A1)-1,),$IV$1:$IV$26)
and copy A28 across as many cols as required (up to the max of 26 cols)
Pressing F9 will regenerate afresh