Thanks:  0
Likes:  0

1. Hi,

I would appreciate some help on this matter:

I'd like to sort a given range of cells (8 columns X variable nš rows) by a given column so that each group of rows, with the same value in the sort column, is "isolated" and a comment is inserted below that group of rows. I would like to do this for all values that appear.

Example:
Sort By
1 45 62 0,03 M 1,74 ...
2 43 62 0.05 M 1.73 ...
4 42 62 0.03 F 1.74 ...
3 Items with 62 ...

3 42 60 0.03 F 1.71 ...
6 40 60 0.03 M 1.17 ...
7 47 60 0.03 F 1.75 ...
8 45 60 0.03 M 1.75 ...
3 Items with 60 ...

...

Thanks,
Nelson

2. Your post is a little vague, but it sounds like you need to sort your data, and then either filter it based on the criteria of your choice located in the column(s) of your choice (to perform the "isolation"), or, after sorting, you need to do a subtotal, to put the comments in underneath the sorted values of your choice, which in your post looks like is a sum of each change in value of column B.

Each one of those 3 operations (sorting, filtering, and subtotaling) are under the Data menu option.

If you need other assistance beyond that, please repost.

3. This will not insert a row will but it will count the number of items which are the same.

then paste this formula into cell I1, or any column of your choice,
=IF(C1=C2,"",COUNTIF(C:C,C1)&" items with " &C1)

This formula assumes you are sorting by col C, if not then change each c to the column you are sorting by.

then drag it down to the last row with data in it.

I know this is short of what you were looking but I hope this helps.

User Tag List

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•