Results 1 to 2 of 2

Thread: How To Look-up The Opening, Closing, High and Low Values Of A Category

  1. #1
    Member
    Join Date
    Apr 2014
    Posts
    45
    Rep Power
    0

    How To Look-up The Opening, Closing, High and Low Values Of A Category

    Thank you for any help,

    in cell G10, how is the formula to get the close/latest final data correspond to the time instead of getting "0" value
    Attached Files Attached Files
    Last edited by mrprofit; 05-10-2014 at 08:53 PM.

  2. #2
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,402
    Rep Power
    10
    Try this as an array formula

    =INDIRECT("B"&MAX(IF(TEXT($A$2:$A$218,"dd-mmm-yyyy h:mm")=TEXT(H10,"dd-mmm-yyyy h:mm"),ROW($B$2:$B$218)*NOT(ISBLANK($B$2:$B$218)), FALSE)))

    Replace with the convenient instead of "dd-mmm-yyyy h:mm"
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

Similar Threads

  1. Protect All Worksheets Before Closing The Workbook
    By rich_cirillo in forum Excel Help
    Replies: 7
    Last Post: 07-14-2013, 10:00 PM
  2. To Fin out Purchases against Closing stock
    By Prabhu in forum Excel Help
    Replies: 1
    Last Post: 05-15-2013, 09:48 AM
  3. Pivot Table Count No of Items per Category
    By Howardc in forum Excel Help
    Replies: 2
    Last Post: 07-04-2012, 10:49 PM
  4. High Lighting Current Date In employee Attendance
    By sanjeevi888 in forum Excel Help
    Replies: 2
    Last Post: 07-01-2012, 10:59 PM
  5. Closing Stock Report With Parameters
    By Prabhu in forum Excel Help
    Replies: 8
    Last Post: 05-08-2012, 02:15 PM

Posting Permissions

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