Rank formula to look at cell colour if cell value is equal??

[danbates]

Hi,

I am just wondering if it is possible to to look at the cell colour to determine the rank if 2 values are the same?

What I have at the moment is:

=RANK.EQ(I4,$I$4:$L$4,0)

Cell I1 is Red = 3
Cell J1 is Blue = 4
Cell K1 is Green =1
Cell L1 is Yellow = 1

So what I would like is to have Green =1 and Yellow =2 just because G comes before Y in the alphabet.

Thanks

Dan

 

[DRSteele]

What makes a cell a certain colour?

Are you in fact trying to rank things by using tiebreakers?

 

[danbates]

Hi,

The colours are just a cell fill and won't change.

Yeah I suppose so. I just don't want there to be two rankings identical within the four places.

Thanks

Dan

 

[DRSteele]

See if this is what you're after:

Ranking with Tiebreakers

Using tiebreakers is frequently required in sports leagues and sales data to come up with winners and losers. We can use a clever trick to rank with tiebreakers, a process otherwise made difficult by the many conditions. Here we have sales data...

www.mrexcel.com

 

[danbates]

Hi,

Thank you for this link.

I'll take a look and see if it can solve my issue.

Thanks again

Dan