**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.*