Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
can you use multiple bin arrays in a frequency formula?
I am trying to get a frequency of a range with a corresponding text
discriptor in another column with my data set? Any ideas would be apreciated |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
can you use multiple bin arrays in a frequency formula?
You'll need to provide more info. Maybe a small sample.
-- Biff Microsoft Excel MVP "hope71" wrote: I am trying to get a frequency of a range with a corresponding text discriptor in another column with my data set? Any ideas would be apreciated |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
can you use multiple bin arrays in a frequency formula?
Hi,
Please explain what you mean by multiple bin arrays? and by frequency of a range? Why don't you show us a sample data layout and show us what you would expect to get out of that data. You can do frequencies with - 1. the FREQUENCY function 2. the COUNTIF function 3. the COUNTIFS function 4. the Historgram tool in the Analysis ToolPak 5. a myrid of SUMPRODUCT functions... If this helps, please click the Yes button Cheers, Shane Devenshire "hope71" wrote: I am trying to get a frequency of a range with a corresponding text discriptor in another column with my data set? Any ideas would be apreciated |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP 4 MULTIPLE ARRAYS? | Excel Discussion (Misc queries) | |||
summed product of multiple arrays | Excel Worksheet Functions | |||
LOOKUP across multiple arrays | Excel Discussion (Misc queries) | |||
sum of multiple arrays? | Excel Worksheet Functions | |||
Multiple Arrays, Vlookup | Excel Worksheet Functions |