Showing numbers of equal value

[Binkx]

Hi

I am using the following formula to rank a list of numbers

=IF(B110="","",RANK(I110,$I$1:$I$220))

I am using Conditional Formatting to indicate the numbers 1 to 10.

Is there a way will will indicate numbers of the same value. i.e if
there was three cells with the number 5 in it, they would all have an =
sign beside the number.


Kieran

 

[Mark Graesser]

Kieran
The following formula will identify duplicate number when entered in conditional formatting

=COUNTIF($A$1:$A$9,A1)>

$A$1:$A$9 indicates the range of numbers and needs to be entered as an Absolute reference so it doesn't change from cell to cell. A1 indicates the active cell and needs to be a Relative reference so it does change from cell tp cell

Conditional formatting does not include number formatting so you won't be able to use an = next to the number, within the same cell. You will have to settle for a bold font, background color, or something else

If you want to put an equal sign in an adjacent cell you can use the formula

=IF(COUNTIF($A$1:$A$9,A1)>1,"=",""

This would be entered directly in the cell, not as a conditional format

Good Luck
Mark Graesse
(e-mail address removed)

----- Binkx > wrote: ----

H

I am using the following formula to rank a list of number

=IF(B110="","",RANK(I110,$I$1:$I$220)

I am using Conditional Formatting to indicate the numbers 1 to 10

Is there a way will will indicate numbers of the same value. i.e i
there was three cells with the number 5 in it, they would all have an
sign beside the number


Kiera

 

[Frank Kabel]

Hi
have a look at
http://www.cpearson.com/excel/rank.htm
('double ranking')
it may what you're looking for
Frank