how to sort two equal numbers

[sicnarf13]

89 87 67 67 65 56
5 10 4 4 8 3 This should be 9
1 34 2 45 3 56 4 ↠→ 67 5 89 6 43 7 54 8 65 9 ↠→ 67
10 87
Can some one solve this for me I am in a Dead end
Line one select the bigest number from column G
Line 3 convert the number from second column to first column
What is the function that I should use to tel it , when it find an
equality it have to go to the second number
I work on that for hours and hours but I am in a dead end
Thank you in advance sicnarf13

 

[Max]

Imo, it's next to impossible to figure out what's happening over there,
going by what you posted

Perhaps you could upload a sample of your file
via a free filehost & post the link to it in response here?

You could use either of these free filehosts:
http://www.freefilehosting.net/
http://cjoint.com/index.php

 

[sicnarf13]

http://cjoint.com/?mFjyjTam3O

 

[Max]

Could you save your file as .xls, and re-upload/paste the new link ?

I'm using xl2003. Unable to open/read your sample which is in xl2007 format.