Need Minimum excluding blank cells

  • Thread starter Thread starter Rita Brasher
  • Start date Start date
R

Rita Brasher

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
 
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
Click to expand...

I don't think you have to, my version of Excel XP ignores them.
 
Ok the problem is my cells are formatted as text, so the MIN and MAX
funstions will not work. Any ideas on how to get "2008-10-10 08:15:54"
to be recognized as a date/time field?
 
Try selecting the range
change all the hyphens to hyphens (or colons to colons).
 
="2008-10-10 08:15:54"*1
Daniel
Ok the problem is my cells are formatted as text, so the MIN and MAX
funstions will not work. Any ideas on how to get "2008-10-10 08:15:54" to be
recognized as a date/time field?
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date comparison between 2 datetime fields 1
Convert Text to Date 4
Bring focus to same cell every time opened?? 2
2-Axis Column Graphs 4
Append Query, New Column help 1
Excel formula, sum the value cell and if empty cell left blank 0
Removing apostrophe from imported data 1
Trendline Issues 4

Back
Top