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?
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?
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
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"XLSUSER" <[email protected]> wrote in message
news:[email protected]...
> 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?
>
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
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
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
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"XLSUSER" <[email protected]> wrote in message
news:[email protected]...
> 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?
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks