Group and count by range of amount

Hi all,

I have a list of 400,000 lines like this:

But I need grouped by amount of 10 and count the number of clients grouped, something like this:

I hope the pictures explain better my problem.

Thanks for your support

Carlos

April 9th, 2015 6:44pm

Hi Carlos,

According to your description, this issue is more related to excel instead of excel development.

The Excel IT Pro Discussions forum is the better place for excel questions, we will move it there for you.

Regards

Starain

Free Windows Admin Tool Kit Click here and download it now
April 9th, 2015 11:16pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics