Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need Minimum excluding blank cells
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need Minimum excluding blank cells
Empty cells are excluded of the MIN function.
Daniel 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need Minimum excluding blank cells
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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need Minimum excluding blank cells
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? 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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need Minimum excluding blank cells
Should not... Can you upload your data in a file to a site such as
www.filedropper. com ? Daniel 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. |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need Minimum excluding blank cells
Try selecting the range
change all the hyphens to hyphens (or colons to colons). Rita Brasher wrote: 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? 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 -- Dave Peterson |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need Minimum excluding blank cells
Hi,
Are the double quotes in the cell or something you added when posting? Mike "Rita Brasher" wrote: 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? 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 |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need Minimum excluding blank cells
="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? 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 |
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need Minimum excluding blank cells
AWESOME! thanks!
Daniel.C wrote: ="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? 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using COUNTA and excluding formulas that gives zero or blank cells | Excel Discussion (Misc queries) | |||
minimum value excluding zero | Excel Programming | |||
average of several cells excluding the minimum | Excel Discussion (Misc queries) | |||
How do I use countif to count values excluding blank cells | Excel Worksheet Functions | |||
Automatic copying data excluding blank cells | Excel Worksheet Functions |