Need Minimum excluding blank cells

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
 
D

dbKemp

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.
 
R

Rita Brasher

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?
 
D

Dave Peterson

Try selecting the range
change all the hyphens to hyphens (or colons to colons).
 
D

Daniel.C

="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
Removing apostrophe from imported data 1
Trendline Issues 4
Append Query, New Column help 1
Error upon exporting results of query to text file 1

Top