View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
sicnarf13 sicnarf13 is offline
external usenet poster
 
Posts: 2
Default how to sort two equal numbers


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