| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Choose From A Range
I have a range A1:A100 with a collection of different numbers. I want a
random number to be selected from the same and displayed in B1. The CHOOSE(RANDBETWEEN(1,100),A1:A100) does not work and requires a manual entry to be made of the whole array which is not possible. Any advice??? Thanx in advance!!!!!! -- Best Regards, FARAZ A. QURESHI |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Choose From A Range
=OFFSET($A$1,RANDBETWEEN(0,99),0)
-- Gary''s Student - gsnu200821 "FARAZ QURESHI" wrote: I have a range A1:A100 with a collection of different numbers. I want a random number to be selected from the same and displayed in B1. The CHOOSE(RANDBETWEEN(1,100),A1:A100) does not work and requires a manual entry to be made of the whole array which is not possible. Any advice??? Thanx in advance!!!!!! -- Best Regards, FARAZ A. QURESHI |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Choose From A Range
Man!!!
U R no student! Sure are a MASTER!!! Thanx a lot!!! -- Best Regards, FARAZ A. QURESHI "Gary''s Student" wrote: =OFFSET($A$1,RANDBETWEEN(0,99),0) -- Gary''s Student - gsnu200821 "FARAZ QURESHI" wrote: I have a range A1:A100 with a collection of different numbers. I want a random number to be selected from the same and displayed in B1. The CHOOSE(RANDBETWEEN(1,100),A1:A100) does not work and requires a manual entry to be made of the whole array which is not possible. Any advice??? Thanx in advance!!!!!! -- Best Regards, FARAZ A. QURESHI |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Choose From A Range
More intuitive to use 1 - 100:
=INDEX(A1:A100,RANDBETWEEN(1,100)) -- Biff Microsoft Excel MVP "Gary''s Student" wrote in message ... =OFFSET($A$1,RANDBETWEEN(0,99),0) -- Gary''s Student - gsnu200821 "FARAZ QURESHI" wrote: I have a range A1:A100 with a collection of different numbers. I want a random number to be selected from the same and displayed in B1. The CHOOSE(RANDBETWEEN(1,100),A1:A100) does not work and requires a manual entry to be made of the whole array which is not possible. Any advice??? Thanx in advance!!!!!! -- Best Regards, FARAZ A. QURESHI |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I randomly choose cells from a range to reproduce elsewhere | Excel Discussion (Misc queries) | |||
| how can i choose the highest number in excel range | Excel Worksheet Functions | |||
| Choose data from a selected range and put result in new column | Excel Worksheet Functions | |||
| Choose From a Range | Excel Worksheet Functions | |||
| Choose. | New Users to Excel | |||
Linear Mode
