View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave F Dave F is offline
external usenet poster
 
Posts: 2,574
Default Array Formula Minimum Excluding Text

The MIN function already ignores text values...

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Adams SC" wrote:

I have a group # in column A. In column G, for each group, I want to take
value in column F - Less the minimum for group. I can get this far, in some
cases I don't have a value in column F, I have a text entry. I want those
entries ignored for the minimum calculation.