Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do get the frequency in 2 columns
i have the data from pivot table, for example i have the two columns of
Travel Distance Total 10 5 15 9 20 36 22 5 25 263 26 4 27 6 28 6 30 23 32 4 33 2 35 10 38 1 40 5 45 5 from this data i want to get the frequency of ranges is like that 0 10 10 25 25 50 50 100 100 300 i want to get the sum from total column,for example from 10 to 25 with in that range from the total distance i need the sum from total column. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I sort the data in 8 columns by two of the columns? | Excel Worksheet Functions | |||
How to swap rows and columns? | Excel Discussion (Misc queries) | |||
Hiding columns and custom views problem | Excel Discussion (Misc queries) | |||
Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | Excel Discussion (Misc queries) | |||
Counting the Contents of Two Columns | Excel Discussion (Misc queries) |