Thread: Minimum formula the excludes zeros
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Joco Joco is offline
external usenet poster
  
Posts: 24
Default Minimum formula the excludes zeros
Max thanks formula works great.
Would quite like to be in Singapore right now, weather in London is not good
thanks again Joco

"Max" wrote:

current formula =min(a5:a35)

Try something like:
=MIN(IF(A5:A350,A5:A35))
Array-enter the formula by pressing CTRL+SHIFT+ENTER
(instead of just pressing ENTER)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Joco" wrote:
My column contains formulars that total weekly share prices, this shows zeros
because that weeks prices are still to be entered, or the week is a future
week.
I require a fomular that shows the minimum total, excluding the zeros.

current formula =min(a5:a35)

Thanks for any help
Joco
Reply With QuoteReply With Quote