+ Reply to Thread
Results 1 to 2 of 2

Inverting data in a row

Hybrid View

  1. #1
    Registered User
    Join Date
    06-27-2008
    Location
    TX
    Posts
    9

    Inverting data in a row

    Hi - How can you invert data in a row assuming that it is ordered the way you want. For Example:

    C3:C10 have values 7,6,4,1,3,10, 8 I'd like to invert it on B3:B10 so that it looks like 8,10,3,1,4,6,7

    Thanks!

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531
    Formula in B3 copied down to B9:
    note your sample date is only 7 rows of data...hence 3:9

    =INDEX($C$3:$C$9,10-ROW(),1)

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1