| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
selecting randomly specific value in a list
Hi all,
I have a list of data with 8 records, these records can be either N/A or the name of a user. Column A User1 User2 User3 N/A User5 N/A N/A User8 I would like to choose at random only the name of one of the user and not selecting the N/A, would it be possible with an excel formula? Thank you Nico |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Randomly Generate Specific Data | Excel Worksheet Functions | |||
| Selecting the value from a randomly selected cell out of a range | Excel Discussion (Misc queries) | |||
| Hi--how do I scramble a list randomly? | Excel Worksheet Functions | |||
| Randomly Generated List / Macro | Excel Worksheet Functions | |||
| How to randomly select from a list with condition | Excel Worksheet Functions | |||
Threaded Mode
