| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to random pick a cell from more than one column
I know how to pick a random cell from one column
=INDEX($A:$A,RANDBETWEEN(1,COUNTA($A:$A)),1) but I need to pick a random cell from more than one column, I tried this: =INDEX($A:$F,RANDBETWEEN(1,COUNTA($A:$F)),1) but it doesn't work. I tried searching the other posts but I couldn't figure it out. Please help, Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pick a Random name from a list. | Excel Discussion (Misc queries) | |||
| Random pick of a cell | Excel Discussion (Misc queries) | |||
| Can excel pick a random cell from a column? | Excel Worksheet Functions | |||
| Pick a Random name from a list. | Excel Worksheet Functions | |||
| random pick names from the list | Excel Discussion (Misc queries) | |||
Threaded Mode
