Lowest and Highest value in a row output

Thank you for all your help, this is what i needed to do to remove those array values which has a 0 in it, then I can find the lowest and highest:

<cfloop condition="arrayFind( PriceArray, '0' )">

<cfset arrayDelete( PriceArray, "0" ) />

</cfloop>
 
<cfset arrayDelete(PriceArray, "0" ) />

<cfset LowestPrice = ArrayMin(PriceArray)>
<cfset HighestPrice = ArrayMax(PriceArray)>

Thanks for all your help on this and have tried with arraymin and arraymax however some prices are 0.00 like the following:

Product ID | Product Name | Price 1 | Price 2 | Price 3 | Price 4 |
        1                   Test             1.00       0.00       0.00       1.29
-------------------------------------------------------------------------------- ----

        2                   Test  2         0.00       3.49       0.00       7.29

So somehow I need to bypass those 0.00 because arraymin returns the 0.00 as the lowest which ok it is, but i need to exclude those so in this example:

Product ID | Product Name | Price 1 | Price 2 | Price 3 | Price 4 |
        1                   Test             1.00       0.00       0.00       1.29

Price 2 and 3 should not be included and Price 1 is lowest price 2 is highest.

Please help.

Hello

You can use the  arrayMin, arrayMax functions in coldfusion

refer to

http://www.adobe.com/livedocs/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/html/wwhelp.htm?context=ColdFusion_Documentation&file=00000355.htm

Thanks

Dan