View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Ron Rosenfeld
 
Posts: n/a
Default second highest value

On Tue, 21 Feb 2006 09:36:23 -0600, Pivotrend
wrote:


didn't work
i still need to know the formula & what to change in the formula to get
the second Highest value , third , forth , fifth & so on


What does "didn't work" mean, exactly?

It is difficult to troubleshoot with such a nebulous description of the
problem.

So far as what to change to get at the third, fourth, etc., look at HELP for
the LARGE command.


--ron