MrExcel Publishing
Your One Stop for Excel Tips & Solutions

formula help


Posted by Dave C on October 25, 2001 3:32 AM

I have 2 columns, one contains priority numbers 0-5 and the other containing 1/4 day time intervals 0.25, .5, .75, 1, etc., all the way up to 30. I have broken these intervals down to four time groups with names, 0.25-1(Tiny), 1.25-3(Small), 3.25-5(Medium), and >5(Large). I need a formula that would calculate how many of which groups there are for each of the priority numbers. Here is an example:
PRIORITY TIME Taken
1 .25
4 1
3 10
3 2
2 4
5 .75
1 5
0 11

My worksheet has the four fields (Tiny, Medium, Small, & Large) for each of the priorities and I need a formula for each of these fields that would count how many of the time groups there are for each of the priorities. The results would be similar to this:

Priority 0 - Tiny
Small
Medium
Large 1
Priority 1 - Tiny 1
Small
Medium 1
Large
Priority 2 - Tiny
Small
Medium 1
Large
Priority 3 - Tiny
Small 1
Medium
Large 1
Priority 4 - Tiny 1
Small
Medium
Large
Priority 5 - Tiny 1
Small
Medium
Large

I hope I have explained this well enough. If not please let me know and I can send you my worksheet. Thanks in advance.

Dave


Posted by Aladin Akyurek on October 25, 2001 3:37 AM

I'm a bit confused about the layout of your data. Sending your workbook would help.

Aladin

======