Sorting
Manage your personal finances in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Sorting

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Location
    Canada
    Posts
    50
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I would like to sort a column of names
    D:1=Joe H
    D:2=Pete I
    D:3=Tory N
    D:4=Etc....

    there are formulas involved in
    D:1=IF(C1=0," ",C1) to arrive at Joe H
    etc
    The sorting is not to working can anyone tell me why....please

  2. #2
    MrExcel MVP Russell Hauf's Avatar
    Join Date
    Feb 2002
    Location
    Portland, OR Area - USA
    Posts
    1,605
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-03-11 17:02, Patrick wrote:
    I would like to sort a column of names
    D:1=Joe H
    D:2=Pete I
    D:3=Tory N
    D:4=Etc....

    there are formulas involved in
    D:1=IF(C1=0," ",C1) to arrive at Joe H
    etc
    The sorting is not to working can anyone tell me why....please
    Try sorting Column C instead.

    -rh

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Location
    Canada
    Posts
    50
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    column c also has formulas in the cells..
    however I guess I figuered it out.. column D needed the cells to be formatted as text...
    and it works!!
    thanks anyhow

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
  •  

 

 
DMCA.com