Formula to show the Lower or Higher Number

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Interval Done @ T. S.C/W Due @ Remaining Minimum Remainin
3,000.0 7,741.0 2,144.4 10,741.0 5,144.4
3,000.0 8,927.6 3,331.0 11,927.6 6,331.0
6,000.0 5,964.1 367.5 11,964.1 6,367.5

Please help, I would like to know the formula or method to read the cell with less time remainin
( so we can read the minimum from each workshhets with different components
Thanks a lo
Shal
 
Shalo,

Assuming the times are in E2:E10, all you need is =MIN(E2:E10)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Something simple , thanks Bob

----- Bob Phillips wrote: ----

Shalo

Assuming the times are in E2:E10, all you need is =MIN(E2:E10

-

HT

Bob Phillip
... looking out across Poole Harbour to the Purbeck
(remove nothere from the email address if mailing direct
 
Back
Top