Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I'm analysing a set of data and I need to provide an out put that shows the
count i.e. frequency and the sum. Consider the values below: local equivalent 1096.68 6000 513.25 174.45 18000 53.86 399.74 118.73 1010.31 19316.81 8066.49 220000 28.92 1567614.68 206.56 667.75 My output should be: Range No. Value 0 - 25,000 4 30,000 25, 001- 50,000 10 275,000 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2002 Analysis ToolPak Regression Analysis Help Requested | Excel Worksheet Functions | |||
Analysis Toolpak-Confidence Level and data analysis questions | Excel Worksheet Functions | |||
Mergers - market concentration - math help | Excel Worksheet Functions | |||
Why " data analysis plus " override " data analysis " once instal. | Excel Worksheet Functions | |||
Analysis ToolPak installed but no Data Analysis option | Excel Discussion (Misc queries) |