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

Thread: sort every second row

  1. #1
    Guest

    Default

    How can you sort by every second row. I would like every second row to go to the colum beside the first row (the row it was under).

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Perth Australia
    Posts
    1,584
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    If your original data is in column A:
    use this formula in B1 and scroll down =IF(C1="",A1,""), then
    use this formula in C2 and scroll down =IF(C1="",A2,"") make sure C1 is blank
    Copy columns B:C and paste special values to convert to values
    Derek

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
  •