Hi,

I have a list of clients with their associated outstanding dollar
amount and their return (%). I would like to know if there is code
that would allow me to break up these clients by return (%) groupings.
For example, I would like to group below 10%, 10% to 17%, and above
17%. So at the client on the list that is just before 10% I would
like to add two rows and put a dollar subtotal in the immediate row
and sum the dollar amounts.

Can anyone help?

Thanks,

Marino

I would
(1) use a 'cheater' column with a formula something like...
=IF(A1<10,1,IF(A117,3,2))
(2) Sort on the return (%) column
(3) Subtotal using the Data Subtotals option.
--
Hope this helps.
Thanks in advance for your feedback.
Gary Brown


"Marino M" wrote:

Hi,

I have a list of clients with their associated outstanding dollar
amount and their return (%). I would like to know if there is code
that would allow me to break up these clients by return (%) groupings.
For example, I would like to group below 10%, 10% to 17%, and above
17%. So at the client on the list that is just before 10% I would
like to add two rows and put a dollar subtotal in the immediate row
and sum the dollar amounts.

Can anyone help?

Thanks,

Marino

On Jul 21, 2:03*pm, Gary Brown
wrote:
I would
(1) use a 'cheater' column with a formula something like...
=IF(A1<10,1,IF(A117,3,2))
(2) Sort on the *return (%) column
(3) Subtotal using the Data Subtotals option.
--
Hope this helps. *
Thanks in advance for your feedback.
Gary Brown

"Marino M" wrote:
Hi,

I have a list of clients with their associated outstanding dollar
amount and their return (%). *I would like to know if there is code
that would allow me to break up these clients by return (%) groupings.
For example, I would like to group below 10%, 10% to 17%, and above
17%. *So at the client on the list that is just before 10% I would
like to add two rows and put a dollar subtotal in the immediate row
and sum the dollar amounts.

Can anyone help?

Thanks,

Marino

Thanks for your input, but I'm trying to make it a bit more automated
and my data changes often. I already have some code built in to pull
my data from a different sheet and sort it but the insertion and
subtotal is a bit more than i know how to do.

Thanks for your help.

Marino