| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
analysis data into range
Any one know how to convert data into range?
Like A 18 B 25 C 120 Then Range 0-100: 43 (i.e. A+B) Range 100-200: 120 (i.e.C) There are more than 8 range, therefore if function might not work effectively |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
analysis data into range
What you expect the results to be with following data (as there several
cobinationns of A to D < 100)? A 18 B 25 C 37 D 40 E 120 "SYL" wrote: Any one know how to convert data into range? Like A 18 B 25 C 120 Then Range 0-100: 43 (i.e. A+B) Range 100-200: 120 (i.e.C) There are more than 8 range, therefore if function might not work effectively |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
analysis data into range
Try the FREQUENCY function.
-- David Biddulph "SYL" wrote in message ... Any one know how to convert data into range? Like A 18 B 25 C 120 Then Range 0-100: 43 (i.e. A+B) Range 100-200: 120 (i.e.C) There are more than 8 range, therefore if function might not work effectively |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
analysis data into range
A1 = data being analyzed
=CEILING(A1,100)-100&" - "&CEILING(A1,100) "SYL" wrote: Any one know how to convert data into range? Like A 18 B 25 C 120 Then Range 0-100: 43 (i.e. A+B) Range 100-200: 120 (i.e.C) There are more than 8 range, therefore if function might not work effectively |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
analysis data into range
I expect to see sum of A,B,C & D. Ie those btw 0-100
"Toppers" wrote: What you expect the results to be with following data (as there several cobinationns of A to D < 100)? A 18 B 25 C 37 D 40 E 120 "SYL" wrote: Any one know how to convert data into range? Like A 18 B 25 C 120 Then Range 0-100: 43 (i.e. A+B) Range 100-200: 120 (i.e.C) There are more than 8 range, therefore if function might not work effectively |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data Analysis | Excel Discussion (Misc queries) | |||
| Why " data analysis plus " override " data analysis " once instal. | Excel Worksheet Functions | |||
| Analysis ToolPak installed but no Data Analysis option | Excel Discussion (Misc queries) | |||
Linear Mode
