+ Reply to Thread
Results 1 to 4 of 4

Which formular should be

  1. #1
    Registered User
    Join Date
    06-17-2011
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    33

    Which formular should be

    Dear all,
    I have a range of data, like
    A1=1
    A2=2
    A3=3
    A4=5
    A5=9
    Which formular should be in column B to get the data from column A but in opposite order:
    B1=9
    B2=5
    B3=3
    B4=2
    B5=1
    Thanks for your help.

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,202

    Re: Which formular should be

    Not sure what you mean, maybe

    in B1 =MAX(A1:A9)
    in B2 & copied down
    =MAX(A2:A10)-ROW(A1)
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  3. #3
    Registered User
    Join Date
    06-17-2011
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    33

    Re: Which formular should be

    Thank you. It can be work, but just ok with sequent order number. I tried with B1=INDEX(A$1:A$5,ROWS(A$1:A$5)+1-ROW(3:3)) and copied down. It works.

  4. #4
    Valued Forum Contributor
    Join Date
    05-23-2011
    Location
    Lahore PK
    MS-Off Ver
    Excel 2007, 2013
    Posts
    627

    Re: Which formular should be

    try the following in B1

    =INDEX($A$1:$A$10,COUNT(A1:$A$10)) and copy down

+ 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