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.

• http://www.mediafire.com/?kyd7ygo5gs02asu

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,

_{Just traded in my old subtlety...
for a NUANCE!}

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.

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

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

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.

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

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

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

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.

There are TWO properties to assign.

1) the STARTING value and

2) the BY value.

I see that you have BOTH incorrectly assigned.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}