challenging sorting cells

[amrezzat]

Hey guys
in the the attached image of excel
i want to see what is the bigger number in the row 49
then sorting these numbers descending and write it in C52
then make a quick equation on in each number ,and this equation is to deduct this figure from each other nine numbers and see what is the zero or above zero result and put it the cell next to this number (column E) starting from E52
example
527.7 is the maximum number so i put it in the c52
and then deduct 527.7from each number ,like the following
41.0-527.7 = negative value (doesnot count)
21.8-527.7= negative value (doesnot count)
....
.... so on
and we will see that the only greater than zero or equal to zero result is only 1 result so we put the figure 1 in the cell E52

and so on on each number

can a brilliant professional give me any ideas about it?

[amrezzat]

Hey guys
in the the attached image of excel
i want to see what is the bigger number in the row 49
then sorting these numbers descending and write it in C52
then make a quick equation on in each number ,and this equation is to deduct this figure from each other nine numbers and see what is the zero or above zero result and put it the cell next to this number (column E) starting from E52
example
527.7 is the maximum number so i put it in the c52
and then deduct 527.7from each number ,like the following
41.0-527.7 = negative value (doesnot count)
21.8-527.7= negative value (doesnot count)
....
.... so on
and we will see that the only greater than zero or equal to zero result is only 1 result so we put the figure 1 in the cell E52

and so on on each number

can a brilliant professional give me any ideas about it?

[shg]

In C52 and copy down =LARGE(D$49:M$49, A52)

[shg]

Threads merged.

Please read the Forum Rules, particularly about posting the same question in more than one forum.

[amrezzat]

i put in different forum in order to see the soultion in vba programming and the functions approach if any

you solution is far from right,please read my question care fully

[shg]

i put in different forum in order to see the soultion in vba programming and the functions approach if any

Best of luck, amrezzat.

[amrezzat]

Hey guys
in the the attached image of excel
i want to see what is the bigger number in the row 49
then sorting these numbers descending and write it in C52
then make a quick equation on in each number ,and this equation is to deduct this figure from each other nine numbers and see what is the zero or above zero result and put it the cell next to this number (column E) starting from E52
example
527.7 is the maximum number so i put it in the c52
and then deduct 527.7from each number ,like the following
41.0-527.7 = negative value (doesnot count)
21.8-527.7= negative value (doesnot count)
....
.... so on
and we will see that the only greater than zero or equal to zero result is only 1 result so we put the figure 1 in the cell E52

and so on on each number

can a brilliant professional give me any ideas about it?

[mikerickson]

If the number put in C52 is the maximum, then all of the results of the subtractions will be negative and "not count".

[amrezzat]

iam counting the number equal to zero and positive
hence , on the first number the maximum number will be only 1 result
but on the second number will be more,

i want first to sort the numbers descending
then make the calculations

so if i choose the second number which is 396 ,and deduct from all the other numbers
the result will be 2 (1 from 527 ,and 1 from 396 itself ) and this 2 value will be in d53 next to the number in c53

[shg]

amrezzat, you have duplicated this post again. You're about to get some time off to ponder the rules.

[amrezzat]

no answer yet

[mikerickson]

If you put
=COUNTIF($D$50:$M$50,">="&C52) in D52 and drag down, it should do what you want.