| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rand() formula
Hello Luke,
Just a guess: If you want to have the most often occuring value, enter into B1: =MODE(A1:A14) Or, if you like its "historical" likelihood: =COUNTIF(A1:A14,MODE(A1:A14))/COUNT(A1:A14) If that's not what you intend give another detailed example, please. Regards, Bernd |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Rand() formula | Excel Worksheet Functions | |||
| how can i set up rand or rand between to give only -1 or 1? | Excel Worksheet Functions | |||
| Duplicates in Rand Formula | Excel Discussion (Misc queries) | |||
| Creating a formula using RAND | Excel Worksheet Functions | |||
| How do I write my formula to automatically regenerate a RAND () i. | Excel Worksheet Functions | |||
Threaded Mode
