Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Needed...
I have a row of numbers from 1 to 26 in cells A1 to Z1 representing numbers
'chosen' at random by 500 unique people. I have another row of numbers representing the 'frequency' that the aforementioned number was chosen in cells A2 to Z2. Example: 1 2 3 4 5 6 7 8 9 10 11 ... 10 4 16 9 23 20 61 13 18 43 17 ... Is there a formula that I could use to calculate the percentage (0%-100%) that each number was chosen? Thanx. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Help Needed | Excel Discussion (Misc queries) | |||
Formula needed | Excel Discussion (Misc queries) | |||
More Help Needed with Count formula | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula needed | Excel Worksheet Functions |