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