ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   how to sort two equal numbers (https://www.excelbanter.com/excel-worksheet-functions/171088-how-sort-two-equal-numbers.html)

sicnarf13

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

Max

how to sort two equal numbers
 
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

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---



sicnarf13

how to sort two equal numbers
 
http://cjoint.com/?mFjyjTam3O
--
sicnarf13


"Max" wrote:

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

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---




Max

how to sort two equal numbers
 
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.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---




All times are GMT +1. The time now is 12:36 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com