Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to do the calculation - 29 Nov?
Does anyone have any suggestions on how to do the calculation?
There is a list of raw data under column A 50, 52, 53, 53, 55, 56 There is a list of numbers under column B 3%, 9%, 5%, 4%, 8%, 8% I would like to create a matrix to count the frequency On X-axis, 50, 51, 52, 53, 54, 55, 56 On Y-axis, 0%, 1%, 2%, 3%, 4%, 5%, 6%, 7%, 8%, 9% Does anyone have any suggestions on how to set the formula to determine the frequency? For example, 4% & 5& will count 1 for each for the number 53. Thanks in advance for any suggestions Eric |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calculation | Excel Worksheet Functions | |||
FFT calculation | Excel Discussion (Misc queries) | |||
Calculation in a Row | Excel Worksheet Functions | |||
How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions |