Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Feb 2003
    Location
    near Blairgowrie, Perthshire, Scotland
    Posts
    72
    Thanks
    0
    Thanked 0 Times in 0 Posts

    marking equal ranks (excel 2003)

    This is probably dead easy, but if you have a column of figures indicating the rank of a set of test marks how do you put - either in the same or an adjacent column - an equals sign next to rank items which appear more than once in the list?

    i.e.

    rank
    2
    1
    3=
    4
    3=
    5
    3=

    and so on...

    Rex Last

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: marking equal ranks (excel 2003)

    Let's say your ranks are in A2:A8.
    Enter the following formula in cell B2:
    <code>
    =IF(COUNTIF($A$2:$A$8,A2)>1,"=","")
    </code>
    Fill down to B8.

    Another option would be to use conditional formatting to highlight the cells with values that occur more than once (by changing the text color, background color and/or borders).

  3. #3
    Star Lounger
    Join Date
    Feb 2003
    Location
    near Blairgowrie, Perthshire, Scotland
    Posts
    72
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: marking equal ranks (excel 2003)

    Thanks Hans, as ever. I suspected IF had something to do with it (I got my brackets in a twist) and the only change I have made is to use a named range. Any way of putting the equals in the same cell (apart from using a couple of helper columns and concatenating them)?

    Rex Last

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: marking equal ranks (excel 2003)

    I don't think it would be a good idea to put the = in the cells themselves, because you'd be modifying the original values (and the moment you add an = to a cell, it's not equal to the others any more <img src=/S/evilgrin.gif border=0 alt=evilgrin width=15 height=15>)

Posting Permissions

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