Rank values and apply random rank to duplicates

[avg1995]

In the cells F4:K4 I have 6 values that are formulated from elsewhere in my workbook. I want to rank these values from 1-6, which is simple using an =RANK. My issue is that sometimes two of these values could be the same. Is there a way to rank all values, but if there are duplicates assign them a random rank that isn't used by another number in the range?

 

[Marcelo Branco]

	E​	F​	G​	H​	I​	J​	K​
3​	estevaoba-->​	3​	4​	1​	5​	2​	6​
4​		432​	349​	753​	349​	652​	178​
5​	Marcelo-->​	3​	4​	1​	5​	2​	6​
6​	MARZIO-->​	3​	4​	1​	5​	2​	6​

@avg1995
There are 3 members trying to help, with different formulas that produce the same results, but it seems that neither does what you want. We're probably misunderstanding your problem. So to solve this dilemma, you should try to show us a sample of your data, along with the expected results.

M.

 

[avg1995]

	E​	F​	G​	H​	I​	J​	K​
3​	estevaoba-->​	3​	4​	1​	5​	2​	6​
4​		432​	349​	753​	349​	652​	178​
5​	Marcelo-->​	3​	4​	1​	5​	2​	6​
6​	MARZIO-->​	3​	4​	1​	5​	2​	6​

<tbody>
</tbody>

@avg1995
There are 3 members trying to help, with different formulas that produce the same results, but it seems that neither does what you want. We're probably misunderstanding your problem. So to solve this dilemma, you should try to show us a sample of your data, along with the expected results.

M.

This solution is exactly what I want, but I couldn't seem to get it to work in my spreadsheet.

I was initially using the online version of excel, I've just downloaded my spreadsheet to the desktop version and all of your solutions work fine. Are COUNTif & RANK not fully supported in the online version?