+ Reply to Thread
Results 1 to 4 of 4

Identified Largest and Smallest VALUES, but need to Identify Location

  1. #1
    Registered User
    Join Date
    09-21-2013
    Location
    TX
    MS-Off Ver
    2010
    Posts
    10

    Identified Largest and Smallest VALUES, but need to Identify Location

    In the attached, I have used SMALL and LARGE to identify the 10 and bottom ten numbers in a grid. What I need to do now is to use the column and row names to identify the day and time of the occurrence.

    A previous post on this topic in another thread provided an array "=IFERROR(INDEX($A$1:$H$1,,MIN(IF($B$2:H13=J6,COLUMN($B$2:$H$13)))),"")" when used, the array generates a number. Even when I format the number to show date and time, it only shows the day. What's is wrong here?

    Book10 as an example.xlsx

  2. #2
    Valued Forum Contributor
    Join Date
    09-15-2011
    Location
    Chennai, India
    MS-Off Ver
    Excel 2010
    Posts
    436

    Re: Identified Largest and Smallest VALUES, but need to Identify Location

    Please try this file.
    Attached Files Attached Files
    Last edited by ramananhrm; 10-07-2013 at 12:14 AM.
    Please click 'Add reputation', if my answer helped you.

  3. #3
    Registered User
    Join Date
    09-21-2013
    Location
    TX
    MS-Off Ver
    2010
    Posts
    10

    Re: Identified Largest and Smallest VALUES, but need to Identify Location

    Thanks. Wow that is a long formula, but it also shows the time from AFTER the one desired.

  4. #4
    Valued Forum Contributor
    Join Date
    10-29-2012
    Location
    Mojokerto,Indonesia
    MS-Off Ver
    Excel 2007
    Posts
    554

    Re: Identified Largest and Smallest VALUES, but need to Identify Location


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Organize data based on Certain Values then smallest to largest
    By thelegazy in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-23-2013, 12:29 PM
  2. 3 largest qty and 3 smallest
    By geng in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-09-2010, 12:20 AM
  3. Largest and smallest sequences
    By smileyc in forum Excel General
    Replies: 8
    Last Post: 01-13-2009, 10:46 AM
  4. Sorting Largest To Smallest
    By all4excel in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-24-2007, 10:30 PM
  5. Returning the Nth Largest / Smallest Values in a Range
    By ExcelTip in forum Tips and Tutorials
    Replies: 0
    Last Post: 08-29-2005, 07:53 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1