[thelist] Excel formula

[Richard Bennett]

Hi,

I'm trying to get a calculation done in an excel file, using formulas only,
 no VB, if possible.

The file i have is like this:

John		Fred		Mike		Minimum
 10		  30		  20		    10
 11		  15		  25		    10

The result I need is the names of those who's number is above the minimum,
ordered by the amount of the number, so:
   A             B              C                D
John		Fred		Mike		Minimum
  10		  30		  20		    10
  11		  15		  25		    10

would give:

1st		2nd		3d
Mike		Fred
John		Fred		Mike

(normally displayed on the same rows as the first part)

I can easily show or hide the name, depending on whether their number is
 above the minimum, but haven't found a way to sort the result by number.

Anyone have an idea?



Hope this is web-related enough... just in case a little tip:



<tip type='css'>

While working on style sheets it's often practical to comment out a few
 rules. Officially this is done with:
.rule{
	width:100px;
	/*padding:10px; */
}

However, an easier way is to simply append any character to the front of the
rule, as CSS will simply ignore any rules that it doesn't know.
So this works fine:
.rule{
	width:100px;
	ppadding:10px;
}

and is faster to type.

</tip>

-------------------------------------------------------