Ranking Function based on number of cells

**kinseld5** · 03-27-2013, 09:47 AM

hi,

I have a ranking function which ranks a cell based on a certain number using the following code:

Please Login or Register  to view this content.

The problem is if a cell in column N has two instances which are the same for each of the three cells you will get the same rank number. Ill explain by trying to represent the output:

Column C Column F Column N ActiveCell (with formula)
D x 2 1
D x 3 3
D x 2 1
D y 6 1
E x 8 1

The 1st and 3rd ceels both have the lowest value and hence get a 1 and therefore the 2nd lowest value gets a 3. What I would like is a function which outputs based on number size and if both the same then the first instance gets a 1, the second instance a 2 and so on resulting in:

Column C Column F Column N ActiveCell (with formula)
D x 2 1
D x 3 3
D x 2 2
D y 6 1
E x 8 1

Can somebody please help as this is bugging me and I cant find a way around it.

Thanks,
Dave

**kinseld5** · 03-28-2013, 07:51 AM

bump no response

**bebo021999** · 03-28-2013, 08:01 AM

Can you upload an example fileand do not forget to write your expected result?

**samba_ravi** · 03-28-2013, 08:06 AM

See the attachment

**bebo021999** · 03-28-2013, 08:23 AM

I can see that the formula in O column is OK with your expectance?

**kinseld5** · 03-29-2013, 12:24 PM

nflsales,

Thank you for your help. you have saved me hours of processing work. Kind of disappointed I didnt think of your method but works perfectly.
Really appreciate it. Thanks again.