+ Reply to Thread
Results 1 to 2 of 2

Multiple MIN queries

  1. #1
    Forum Contributor
    Join Date
    08-17-2009
    Location
    West Midlands
    MS-Off Ver
    Excel 2016
    Posts
    213

    Multiple MIN queries

    Can anyone help?

    I have a a dataset where column A is a list of days and colum B is a list of times, e.g.

    Col A Col B
    01.01.2011 09.15
    01.01.2011 11.33
    01.01.2011 10.27
    02.01.2011 07.31
    02.01.2011 14.01
    03.01.2011 12.00
    03.01.2011 09.54

    etc...

    I'm looking for a formula that would return the min value in column B for EACH day. Any ideas?

    Thanks

    Steve

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Multiple MIN queries

    Hello,

    use a pivot table, like in the attached. To get started with pivot tables, check out http://peltiertech.com/Excel/Pivots/pivotstart.htm

    cheers,
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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