Results 1 to 4 of 4

Min If with a Twist

Threaded View

  1. #1
    Registered User
    Join Date
    12-30-2013
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    39

    Min If with a Twist

    Hi guys,

    I am looking to summarize a report's findings, and I would like to do so with a formula rather than updating it manually each month. I have a list full of multiple categories, and each category contains several locations. This is what I would like the formula to do: Look for the minimum value of savings within the same location, then return the category in which this minimum falls into. Right now, I am using a {=min(if function which correctly returns the minimum savings for each location, but I would like it to return the category name for which the minimum savings falls under.

    This description of my problem is pretty confusing I bet so I will attach a sample spreadsheet. Please note that there are two small tabs. My actual spreadsheet of course has many more categories than this.

    Thanks,

    David
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Sort with a twist
    By silverxx12 in forum Excel General
    Replies: 2
    Last Post: 01-29-2013, 02:08 PM
  2. #div/0! with a twist
    By Bjordion in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-11-2011, 03:53 PM
  3. Sum with a twist
    By ace4andy in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-26-2008, 03:08 AM
  4. Sumif with a twist
    By Bruce in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 06:05 PM
  5. [SOLVED] Sumif with a twist?
    By Bruce in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1