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

Thread: Sorting Question

  1. #1
    Board Regular HunterN's Avatar
    Join Date
    Mar 2002
    Location
    Maryland
    Posts
    479
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hello,

    In my wksht I have a column whose header is Project Number. Under this is the word Total and then the list of Project Numbers. I want to sort this worksheet by rows, using the Project Number. This all works fine BUT the row that has the totals in it now ends up at the bottom. I don't want the Totals row to move, just the other rows. I thought I was doing it right but it always takes the Total row to the bottom. Can anyone help?

    Thanks in advance, you guys are great!

  2. #2
    MrExcel MVP Ivan F Moala's Avatar
    Join Date
    Feb 2002
    Location
    Auckland, New Zealand
    Posts
    4,209
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-05-10 05:39, HunterN wrote:
    Hello,

    In my wksht I have a column whose header is Project Number. Under this is the word Total and then the list of Project Numbers. I want to sort this worksheet by rows, using the Project Number. This all works fine BUT the row that has the totals in it now ends up at the bottom. I don't want the Totals row to move, just the other rows. I thought I was doing it right but it always takes the Total row to the bottom. Can anyone help?

    Thanks in advance, you guys are great!
    Hi Hunter....am I missing something ??
    Why not just select the cell under Totals
    onwards and sort ??
    If There is something I'm missing then please
    clarify ad hopefully we can help you further.
    Kind Regards,
    Ivan F Moala From the City of Sails

  3. #3
    Board Regular
    Join Date
    May 2002
    Location
    Ipswich, Suffolk, England
    Posts
    136
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    You could merge the cells in row 1 & 2, and re-enter the column heading so that Project number total becomes one cell

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
  •