need a formula for maximum

[RSEKAR]

Dear Sir,
In both G and O column contain numerical data. Range (G10:G950) and (O10:O950)
Both columns contain 0 Values also.
The formula should display the Maximum value in (O10:O950) for the data > 0 in (G10:G950)
Thanking you in advance.

 

[number kruncher]

Try,

=if(sum(G10:G950)>0,large(o10950,1),"")

 

[Richard Schollar]

Hi

Version of Excel?

Try this:

=MAX(IF(G10:G950>0,O10:O950))

which is an array formula and so must be entered using Ctrl+Shift+Enter.

 

[RSEKAR]

Dear Sir,
=IF(SUM(G10:G950) > 0,LARGE(O10:O950,1),"")
The above formula display the value as 996.97 where as the correct value is 8.40
Some more information. The G column numbers are derived by paste link method from some other column. The O column numbers are derived from formula.

 

[RSEKAR]

Dear Mr.Richard Schollar,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
Your formula displays the correct value as 8.40<o></o>
Excel 2002 and OS XP
=MAX(IF(G10:G950 > 0,O10:O950))<o></o>
Thanking you,<o></o>

 

[number kruncher]

If you could supply a sample of your data, to aid assistance given?

 

[Richard Schollar]

=if(sum(G10:G950)>0,large(o10950,1),"")

Only checks if the Sum range is greater than zero before taking the largest value from the range ie it doesn't restrict the range from which the max is to be taken to O column cells where the corresponding G column cells are greater than zero.