Excel random number formulas

Question

I need to generate acronyms consisting of the letter "i" + a random number between 1 and 7. Currently I do it with this formula:

= CONCAT ("i"; RANDBETWEEN (1; 7))

For example the output can be i4.

Then I need to generate a second abbreviation, but the following number "i" must be different from the previous one, therefore from i1 to i7 excluding i4. I have tried several formulas but without success.

Gary's Student · Accepted Answer · 2021-01-01 15:33:45Z

2

Using Excel 365 and the US Locale, in a cell enter:

="i" & SORTBY(SEQUENCE(7),RANDARRAY(7))

answered Jan 1, 2021 at 15:33

Gary's Student

96.9k10 gold badges66 silver badges104 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Excel random number formulas

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related