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

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

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

.