Rank Worksheet Function

[nrage21]

I am having an awful time creating a rank function for 6 rows. Three of these rows contain a 'zero' value that the rank function is considering ties... I want rank to assign the last possible number to a zero value. Lower values should be considered 1st in ranking. By the way I am using concatenate at the same time.

Please refer to the attached spreadsheet for clarification.

I have also included a column (highligthed in green) displaying my desire results.

I'm sure that someone will solve this in a minute.

Thx in advance.

nrage21

[DonkeyOte]

one way based on your sample file:

Please Login or Register  to view this content.

[nrage21]

Thx... your modification worked out