Anyone can help me

[Thiyagu8423]

I would like to have formula to get random number from 1 to 55..total 6 number and it's should be in horizontal line and unique and from lower to upper..example of number in below..should generate like below

5,9,11,45,48,55

 

[Thiyagu8423]

I would like to have formula to get random number from 1 to 55..total 6 number and it's should be in horizontal line and unique and from lower to upper..example of number in below..should generate like below

5,9,11,45,48,55

Anyone can support Me to get formula

 

[myall_blues]

This is not guaranteed to be unique but it will be most of the time.

Book1
	H	I	J	K	L	M
4	6	45	3	25	36	34
Sheet1

Cell Formulas
Range	Formula
H4:M4	H4	=INT(RAND()*55+1)

 

[Thiyagu8423]

THANK YOU...ITS WORK

 

[myall_blues]

THANK YOU...ITS WORK

Happy days!