Array Formula (I think)

  • Thread starter Thread starter Kris Taylor
  • Start date Start date
K

Kris Taylor

Hi!

Here is my problem. I have two different columns of equal size that
contain numerical values. Column C contains values from 0-1200, while
Column T contains values that range from 0-8. I need to fill in a
chart with 4 different ranges for each value in column T (0-8). The
ranges are as follows: 0-199.9, 200-399.9, 400-599.9 and 600-1200.

The table looks something like this:

Range 1| Range 2| Range 3| Range 4|
0
1
2
3
..
..
8

What I really need is a formula that looks through column T for each
number (0 through 8) and then checks column C and groups the data into
the different ranges. Hopefully, someone can help me with this.

Thank you so much and I look forward to seeing any responses to my
query.

Kris Taylor
 
assume the space under range1 and next to 0 is U2

U2: =if($C2<=199.9,$T2,"")
V2: =if(and($C2>199.9,$C2<=399.9,$T2,"")
W2: = if(and($C2>399.9,$C2<=599.9,$T2,"")
X2: =if(and($C2>599.9,$C2<=1200,$T2,"")

Then select U2:X2 and drag fill down the column
 
Hi Tom,

Thanks for the reply! I still seem to have problems however.
Firstly, there seems to be missing a parenthesis in all formulas
except the first. I inserted it before the "t" value and always get
nothing. Also, the first equation doesn't seem to be counting the
number of occurences either. For some reason, no matter what, I get
5.3 as my value. 5.3 is the value of T2 and I think the first formula
is only checking the one row, whereas I need it to check the entire
columns and count the number of occurences.

Hopefully my explanations are clear enough for you to comprehend the
problem.
If you need any further clarifications, feel free to ask!

Thanks in advance,

Kris Taylor
 
Back
Top