Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Sort and Insert

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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. #2
    MrExcel MVP Tom Urtis's Avatar
    Join Date
    Feb 2002
    Location
    San Francisco, California USA
    Posts
    11,162
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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. #3
    New Member
    Join Date
    Mar 2002
    Location
    Northern Ireland
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.



Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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