Sort and Insert

nmspt

New Member
Joined
Mar 28, 2002
Messages
2
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
 

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.
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.
 
Upvote 0
This will not insert a row will but it will count the number of items which are the same.

Sort your data by your desired column,
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.
 
Upvote 0

Forum statistics

Threads
1,213,546
Messages
6,114,256
Members
448,557
Latest member
richa mishra

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top