Excel 2007 Function question

[BMcAnly]

First of all, my apologies if this is a repeat question but I wasn't able to locate what I'm trying to do. I have a list of financial data which lists, among other things, days delinquent. What I am trying to do is group those by 0-25 days, 26-50 days, 51-75 days. 76-100 days, and 100 + days. What is the best way to go about it? The other functions I want to do can be completed with a pivot table. Exel 2010. Thank you in advance for your help!

When you're standing on the edge of a cliff, a step forward is not progress.

 

[SkipVought]

hi,

many of us cannot download data due to company security restrictions. Please post all example data here directly.

Your issue can be done IN your Pivot Table using the GROUP feature.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[BMcAnly]

Thanks, Skip!

Import date current balance days delinquent
1/1/2011 1905.06 1
1/1/2011 240.9 1
1/1/2011 138.26 1
1/1/2011 1836.25 2
1/1/2011 1860.27 2
1/1/2011 634.91 2
1/1/2011 418.06 3
1/1/2011 158.54 3
1/1/2011 406.56 3
1/1/2011 0 4
1/1/2011 556 4
1/1/2011 169.21 4
1/1/2011 242.7 5
1/1/2011 1255.04 5
1/1/2011 0 5
1/1/2011 549.67 6
1/1/2011 0 6
1/1/2011 0 6
1/1/2011 1037.56 7
1/1/2011 0 7
1/1/2011 0 7
1/1/2011 665.4 8
1/1/2011 230 8
1/1/2011 420 8
1/1/2011 145 9
1/1/2011 0 9
1/1/2011 0 9
1/1/2011 0 10
1/1/2011 0 10
1/1/2011 542.51 10
1/1/2011 0 11
1/1/2011 348.84 11
1/1/2011 0 11
1/1/2011 0 12
1/1/2011 0 12
1/1/2011 1883.09 12
1/1/2011 0 13
1/1/2011 188.95 13

This data sample only goes to 13 days delinquent, but I think it shows what I have to work with. Let me know if you need more info.

When you're standing on the edge of a cliff, a step forward is not progress.

 

[SkipVought]

Did you try the suggestion I made? You made no mention of it.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[BMcAnly]

That is moving me in the right direction. Let me play with it a little bit. Thanks for your gelp, Skip!!

When you're standing on the edge of a cliff, a step forward is not progress.

 

[BMcAnly]

You didn't gelp me, you helped me. . . . .

When you're standing on the edge of a cliff, a step forward is not progress.

 

[SkipVought]

;-)

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[BMcAnly]

OK, so that has me about 95% there. In using the Group function, the first group (0-25 days) is 26 increments. The remainder are then grouped in increments of 26 as well, but they need to be in increments of 25 (26-50 days, etc.). Did I miss something?

When you're standing on the edge of a cliff, a step forward is not progress.

 

[SkipVought]

There are TWO properties to assign.

1) the STARTING value and

2) the BY value.

I see that you have BOTH incorrectly assigned.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]