Results 1 to 3 of 3

Thread: One Minus The Next Highest Number
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Jan 2016
    Posts
    14
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default One Minus The Next Highest Number

    Hello,

    I am looking for advice on a formula to basically minus one from the next highest number.

    If A1 to A8 have the numbers:

    3
    5
    1
    8
    4
    6
    2
    7

    if the number 2 is removed from the above then i want a formula to correct the order in cells B1 to B8 so they would read:

    2
    4
    1
    7
    3
    5

    6

    Any advice much appreciated.

  2. #2
    Board Regular
    Join Date
    Dec 2008
    Posts
    6,657
    Post Thanks / Like
    Mentioned
    5 Post(s)
    Tagged
    0 Thread(s)

    Default Re: One Minus The Next Highest Number

    Try this in B1 and fill down.

    =IFERROR(RANK(A1,$A$1:$A$8,1),"")

  3. #3
    New Member
    Join Date
    Jan 2016
    Posts
    14
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Thumbs up Re: One Minus The Next Highest Number

    Quote Originally Posted by jasonb75 View Post
    Try this in B1 and fill down.

    =IFERROR(RANK(A1,$A$1:$A$8,1),"")

    Yep perfect, well played!

Some videos you may like

User Tag List

Tags for this Thread

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
  •