Announcement

Collapse
No announcement yet.

Excel Rows are Jumbling

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Excel Rows are Jumbling

    Hi Everyone,

    Iam having an issue with my Excel - 2007
    in my excel sheet i have Rows = 6565 & Column = A-AZ.

    Now you can image this is a big file.

    my second column name is Project ID : it starts from 100191 and so on....

    in the middle of 4634 row the,,, the sequence is not correct.. (the rows are jumbled / up and down..).

    so i sort them..

    after few days, some where in the middle the sequence again changed..

    can any one suggest me solution and cause of this problem..


    Thanks for your valuable time and considerations.

  • #2
    Re: Excel Rows are Jumbling

    I assume someone is selecting a block of cells and sorting on another field -- that is the only cause I can think of unless there is a formula involved in generating the project ID
    Tom Jones
    MCT, MCSE (2000:Security & 2003), MCSA:Security & Messaging, MCDBA, MCDST, MCITP(EA, EMA, SA, EDA, ES, CS), MCTS, MCP, Sec+
    PhD, MSc, FIAP, MIITT
    IT Trainer / Consultant
    Ossian Ltd
    Scotland

    ** Remember to give credit where credit is due and leave reputation points where appropriate **

    Comment

    Working...
    X