Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 9,221
Default 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
---


  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default 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
---



  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 9,221
Default 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
---


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do i make negative numbers equal zero benny1 Excel Worksheet Functions 2 October 23rd 06 08:46 PM
How do I determine which numbers in a list equal a given sum? infraterra Excel Discussion (Misc queries) 11 October 7th 05 11:39 PM
check if 2 cells are equal but only if they contain numbers not i. Peter Boardman Excel Worksheet Functions 4 April 17th 05 08:16 PM
Find combinations of numbers to equal a value jubu Excel Worksheet Functions 1 March 18th 05 12:46 PM
Random Numbers Not Equal to Joe Blow Excel Worksheet Functions 3 January 3rd 05 07:01 PM


All times are GMT +1. The time now is 05:31 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright 2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"