Results 1 to 5 of 5

Thread: =MIN(IF(

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. 05-30-2014, 08:33 PM #1
    xander1981
    xander1981 is offline
    Member xander1981's Avatar
    Join Date
    Oct 2012
    Posts
    81
    Rep Power
    13
    Sorry Skywriter I should have said I have done that but still not working.
    Reply With Quote Reply With Quote
  2. 05-31-2014, 05:59 AM #2
    Rick Rothstein
    Rick Rothstein is offline
    Forum Guru Rick Rothstein's Avatar
    Join Date
    Feb 2012
    Posts
    662
    Rep Power
    14
    Quote Originally Posted by xander1981 View Post
    Sorry Skywriter I should have said I have done that but still not working.
    What exactly to you mean when you say it is "not working"? Your formula, using CTRL+SHIFT+ENTER to commit it, works for me. I will note that the formula outputs a time serial value (that is, a floating point number) which requires the use of Cell Formatting in order to select a proper time display format for the value.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. what shoud i do to have one sheet of every 1hour data & min max data with vb code
    By CORAL in forum Excel Help
    Replies: 2
    Last Post: 03-08-2014, 04:22 PM
  2. Min, Max, Average Vba for Situation
    By afm1985 in forum Excel Help
    Replies: 1
    Last Post: 09-14-2013, 07:16 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules