Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Mark
 
Posts: n/a
Default sort data with the same result

Hi,

I have sum data of five columns:

col1 col2 col3 col4 col5 sum_of_5_columns item
5 6 6 20 30 67 1
6 5 6 25 20 62 3*
3 5 4 28 22 62 2
etc..

*less sum of last three columns

I used function LARGE but occured the same result in
sum_of_5_columns. i don't want equal position..

I'd like create (in column item) function with show
position from max to min sum_of_5_columns.
If sums are equal then count sum of last three columns
(3,4,5)
If sums are still equal then count sum of last two columns
(4,5)
If sums are still equal then count value of five column (5)

Remark: My data can't be sort by excel.

Any help in function or VBA function will be appreciated.


I use excel 2k.
Best Regards
Mark
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
maybe the following helps:
http://www.cpearson.com/excel/rank.htm

--
Regards
Frank Kabel
Frankfurt, Germany

"Mark" schrieb im Newsbeitrag
...
Hi,

I have sum data of five columns:

col1 col2 col3 col4 col5 sum_of_5_columns item
5 6 6 20 30 67 1
6 5 6 25 20 62 3*
3 5 4 28 22 62 2
etc..

*less sum of last three columns

I used function LARGE but occured the same result in
sum_of_5_columns. i don't want equal position..

I'd like create (in column item) function with show
position from max to min sum_of_5_columns.
If sums are equal then count sum of last three columns
(3,4,5)
If sums are still equal then count sum of last two columns
(4,5)
If sums are still equal then count value of five column (5)

Remark: My data can't be sort by excel.

Any help in function or VBA function will be appreciated.


I use excel 2k.
Best Regards
Mark


  #3   Report Post  
Mark
 
Posts: n/a
Default

Thnx Frank,
interesting link, but i haven't found solution
Regards
Mark

-----Original Message-----
Hi
maybe the following helps:
http://www.cpearson.com/excel/rank.htm

--
Regards
Frank Kabel
Frankfurt, Germany

"Mark" schrieb im Newsbeitrag
...
Hi,

I have sum data of five columns:

col1 col2 col3 col4 col5 sum_of_5_columns item
5 6 6 20 30 67 1
6 5 6 25 20 62 3*
3 5 4 28 22 62 2
etc..

*less sum of last three columns

I used function LARGE but occured the same result in
sum_of_5_columns. i don't want equal position..

I'd like create (in column item) function with show
position from max to min sum_of_5_columns.
If sums are equal then count sum of last three columns
(3,4,5)
If sums are still equal then count sum of last two

columns
(4,5)
If sums are still equal then count value of five column

(5)

Remark: My data can't be sort by excel.

Any help in function or VBA function will be

appreciated.


I use excel 2k.
Best Regards
Mark


.

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
Help with data not getting plotted Scott Ehrlich Excel Discussion (Misc queries) 2 January 25th 05 06:17 AM
Help with data not getting plotted Scott Ehrlich Charts and Charting in Excel 1 January 23rd 05 06:15 PM
Amount or Numbers in Words ron New Users to Excel 6 December 24th 04 08:32 PM
Data > Sort function amnesia? Dave D Excel Discussion (Misc queries) 1 November 29th 04 11:44 PM
cells lose relativity to other WorkSheets after data sort? Ed Murray - ALPCO Excel Worksheet Functions 1 November 8th 04 08:02 PM


All times are GMT +1. The time now is 02:32 PM.

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

About Us

"It's about Microsoft Excel"