Excel Array Formula Series #8: FREQUENCY function

I'm having trouble setting up Solver to work with a Frequency array.
I'm wanting to set the Adustable Cells as the Bin values for the array, set
contraints on the Frequency Results, with the Target Cell being the a sum of
all frequency results, also constrained to the known total of data values.
I've also set contraints on the Bin values so that they are <= the next bin
value.

I always get a "Solver could not find a feasible solution". Any assistance
would be great!

Hi,

I have a list of names in column B, separated by categories. Each category name is followed by list of names. Each category has different # of names under it.

For eg. a category name in cell B4 is followed by 6 names (B5:B10); then follows a blank cell (B11); then 2nd category name in a cell (B12) followed by 4 names (B13:B16); and so on and so forth.

I want to fill the column A with numbers against the names (in column B) only and not against the blank cells and category names.

I can fill the series using + sign or "=A5+1" which is not what I am looking for. When I add a name in any of the categories or delete a name from a category, the fill series has to be updated completly, from below the changed row, manually.

I tried the following array formula -

{=IF(AND(COUNTIF(B6,"*")>0,COUNTIF(B5,"*")>0),(IF(COUNTIF(B4,"*")>0,B5+1,B3+1)),"")}

This formula returns 1 in A5 but each subsequent cell in column A is giving #VALUE! except the cells in column A that have category name or blank cell in column B.

So it is doing one part i.e. not numbering cells against category names and blank cells but it is not adding the way I want them to.

Would greatly appreciate if someone can help me with this.

Thanks.

Mac Excel 2008 v.12

Newb here. I searched but I'm not finding a solution.

I have a list of 691 numbers that I rounded (yes with the function, pat on back) that I need to find the frequency of each. So, I found the highest number (85) and lowest (1) and made a bin (1-85).

=frequency (E2:E693,F2:F86)

This gives the frequency of just the first number (1 at 3 times). It ignores the rest of the bin. If I try to control drag the rest of the list it gives me errors and impossible numbers.

This is a list I will be adding numbers to on a daily basis. The end result will be a histogram.

So, is this the best way to perform this task?

Why isn't the frequency function applying to the entire bin?

thanks in advance!

What excel function(s) can I use if I want to generate some random words with a certain frequency?

For example, I want:
Apple to appear 10% of the time
Banana to appear 20% of the time
Cherry to appear 20% of the time
Dates to appear 50% of the time

Thank you!

Hello;

1) I need to calculate M43:: sum[m=1 to m=9] G(m)*sin(m*x) for each value of tabulated x in column L.
The 9 values of "m" are tabulated in $D$21:$D$29
The 9 values of G(m) are tabulated in $C$21:$C$29
The first x value is in cell L43

Can someone please help in deriving the array formula to be entered in M43 ??
For other values of x in L44, L45, ... one would simply copy M43 and paste in M44, M45, ...

2) If it's not too much trouble, how about:
N43:: -sum[m=1 to m=9] G(m)*cos(m*x)/m for each value of tabulated x

Your help would be greatly appreciated.

Regards.

Hi,

I have 2 data series with different time resolution, but I'd like to put them on the same resolution. I'll give you a simplified example:

Series 1:
time1; force1
0; 2
1; 4
2; 2
3; 1
4; 7

Series 2:
time2; force2
0; 5
2; 3
4; 1
6; 4

So, I want to merge these 2 series, so they both refer to 1 time data set. It would look like:

time; force1; force 2
0; 2; 5
1; 4;
2; 2; 3
3; 1;
4; 7; 1
and so on..

How can I do that?

Thanks!
MLC

How to create a number series within an array formula, I mean, the series starts with 1 and will finish with 8 for example;
{1;2;3;4;5;6;7;8} - It will be the result within my array formula.
In Aij matrix means i=1 to 8 {i+1;i+1;i+1;i+1;i+1;i+1;i+1;i+1}.
I need to retrieve it within an array formula.

How can I do that just using an array formula.



Luthius

I have a list like this:

Sheet1

  A B C 1 Alfa Status D 75 2 Bravo Status A   3 Charlie Status B 483 4 Delta Status B 78 5 Echo Status C   6 Foxtrot Status A   7 Golf Status B   8 Hotel Status B 12 9 India Status A   10 Juliett Status A 405 11 Kilo Status C   12 Lima Status B   13 Mike Status A   14 November Status B 27 15 Oscar Status B 13 16 Papa Status B   17 Quebec Status C 140 18 Romeo Status B 426 19 Sierra Status C 484 20 Tango Status D 197

Excel tables to the web >> Excel Jeanie HTML 4

I want to single out all Status B values, and put them in a new table in descending order.

In this case, it would look like this:

Sheet1

  A B C 10 Charlie Status B 483 11 Romeo Status B 426 12 Delta Status B 78 13 November Status B 27 14 Oscar Status B 13 15 Hotel Status B 12

Excel tables to the web >> Excel Jeanie HTML 4

So I need to ignore blank values, determine which row has the highest quantity, and then return the value in column A and column C.

I know I can use array formulas to a certain extent, but I'm stumped as to how to store the row of the highest values in the array while ignoring blanks. Any ideas?

Hi,
I've run into an issue that I'm not quite sure how to solve. I think that using an array formula will be the right approach, but I'm unsure. Here's what I would like to do:

I have several elements to handle. First, I have a constant value, let's call it "A". I also have two columns, B and C. I would like to check whether "A" is greater than the first, second, third, etc. values in B, and generate 1 if it is, and 0 if it is not. These 1s and 0s would go into one array.

I would then like to check whether "A" is less than the first, second, third, etc. values in C, and generate 1 if it is, and 0 if it is not. These 1s and 0s would go into another array.

I would then like to take the sumproduct of those two arrays.

I'm not too familiar with the syntax of array formulas in Excel (I have fairly extensive knowledge of them from various calculus and Linear Programming classes, as well as Java). Any help would be much appreciated!

Thanks,
3LD

I am not able to find a way to fill a series when the formula contains a functions. Forexample:
=weeknum($A$1)+1
I would like to fill the cells next to this formula by:
=weeknum($A$1)+1
=weeknum($A$1)+2
=weeknum($A$1)+3
=weeknum($A$1)+4
and so on

I have a date in cell A1:
05/05/2009