Question description:
This user has given permission to use the problem statement for this blog.
i need a formula to pick for exemple 10 random cells from a table with 30 column 1 to 30 and in down A to J
the result i need it is something like this:5B, 27E, 2J.....etc
Solved by M. J. in 60 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert
28/02/2018 - 01:07
Hello there, thanks for choosing Got It Pro - Excel.
User
28/02/2018 - 01:07
hello
Excelchat Expert
28/02/2018 - 01:08
Can you please upload your excel file here ?
User
28/02/2018 - 01:08
i don`t have one
Excelchat Expert
28/02/2018 - 01:09
Can you please give us example in blank sheet ?
User
28/02/2018 - 01:09
ok
User
28/02/2018 - 01:12
in blue column
User
28/02/2018 - 01:12
i want random pick from red
User
28/02/2018 - 01:12
random
Excelchat Expert
28/02/2018 - 01:14
Please let me see.
User
28/02/2018 - 01:16
a moment please
User
28/02/2018 - 01:16
to undersand
User
28/02/2018 - 01:16
like that
User
28/02/2018 - 01:17
and now i whant random picks
User
28/02/2018 - 01:17
like
User
28/02/2018 - 01:17
c4
User
28/02/2018 - 01:17
b1
Excelchat Expert
28/02/2018 - 01:17
Ah so you have the same numbers in each column
Excelchat Expert
28/02/2018 - 01:17
?
User
28/02/2018 - 01:17
ies
User
28/02/2018 - 01:17
and foe example
User
28/02/2018 - 01:17
c can be one time
User
28/02/2018 - 01:17
in random poicks
User
28/02/2018 - 01:18
picks
User
28/02/2018 - 01:18
if i whant 3 random picks
User
28/02/2018 - 01:18
it will be 3 leter with 3 numers
User
28/02/2018 - 01:18
not 2 letter
User
28/02/2018 - 01:18
with 2 numer
User
28/02/2018 - 01:18
and one with one
User
28/02/2018 - 01:19
letter can`t repet at random picks
Excelchat Expert
28/02/2018 - 01:19
Letter in A column ?
User
28/02/2018 - 01:19
yes
User
28/02/2018 - 01:29
like that
User
28/02/2018 - 01:29
but
User
28/02/2018 - 01:29
not just
User
28/02/2018 - 01:29
1
User
28/02/2018 - 01:29
h3, c7, q2
Excelchat Expert
28/02/2018 - 01:30
Yes I understand just trying to create a formula that will works for you.
User
28/02/2018 - 01:30
ok
Excelchat Expert
28/02/2018 - 01:38
Can we create a random list from A1:A10 only with unique values, then in another formula to get random from B2:F10 and concatenate those two random letter and numbers ?
User
28/02/2018 - 01:39
yes
Excelchat Expert
28/02/2018 - 02:00
I get a list from A column with unique values, now trying to get the random numbers but in rows.
Excelchat Expert
28/02/2018 - 02:07
Can you
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.
