Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Array formula SUMIF with 2D sum_range array | Excel Worksheet Functions | |||
Array formula: how to join 2 ranges together to form one array? | Excel Worksheet Functions | |||
Find specific value in array of array formula | Excel Worksheet Functions | |||
meaning of : IF(Switch; Average(array A, array B); array A) | Excel Worksheet Functions | |||
Array Formula - using LEFT("text",4) in formula | Excel Worksheet Functions |