View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Rita Brasher Rita Brasher is offline
external usenet poster
 
Posts: 17
Default Need Minimum excluding blank cells

Mine returns 0 as the minimum when the other cells are populated...



dbKemp wrote:
On Nov 4, 1:20 pm, Rita Brasher wrote:
Office XP Professional

I have a range of cells, some may be empty - others will not. I need to
find the minimum value for the populated cells. How do I exclude the
empty cells in my formula?

Thanks in advance for any help!

Rita Brasher
Project Engineer / IPEG Int'l MIS and Training
FedEx Express


I don't think you have to, my version of Excel XP ignores them.