Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hello,
I would need some help. Can someone tell me which formula i have to use in order to calculate the MIN value on column B excluding the 0 values? A B day 1 1.25 day 2 1.22 day 3 1.1 day 4 1.11 day 5 1.09 day 6 1.06 day 7 0 day 8 1.01 day 9 1.02 day 10 0.99 day 11 0.95 day 12 0.9 day 13 0 day 14 0.85 day 15 0 day 16 0.87 day 17 0 day 18 1.1 day 19 1.2 day 20 0.75 day 21 0.9 day 22 0 day 23 0.75 day 24 0.76 day 25 0 day 26 0.5 Thanks for your help |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calculate A Date Excluding Weekends And Holidays | New Users to Excel | |||
How to calculate the difference between two dates, excluding Sund. | Excel Discussion (Misc queries) | |||
Calculate time (excluding weekend (48 hrs)) | Excel Worksheet Functions | |||
Calculate MIN excluding zero | Excel Discussion (Misc queries) | |||
Calculate A Date Excluding Weekends And Holidays | New Users to Excel |