Results 1 to 3 of 3

Find minimum value in 2 columns based on multiple criteria

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-19-2012
    Location
    Tacoma, Washingtonn
    MS-Off Ver
    Excel 2019
    Posts
    334

    Find minimum value in 2 columns based on multiple criteria

    In my Test Worksheet I am looking to auto populate the column shaded in gray with a 1 or a 2 based on the following rules:

    1. FIRST take the minimum value under the letter "G" and give that a value of "1".
    2. Not using the value under the letter "N" next to the value used under "G", take the minimum value under "N" from the remaining 3 numbers and give that a value of "2".

    If there are duplicate minimum numbers under "G", use the one which allows you to use the smallest number under "N". I hope this is doable. I manually entered the 1's and 2's in the first 9 instances to show what the results should be.

    Thank you...
    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. [SOLVED] Find Minimum or Maximum with Multiple Criteria Not Working
    By mycon73 in forum Excel General
    Replies: 3
    Last Post: 04-24-2016, 11:45 PM
  2. Find and Delete rows based on criteria in multiple columns
    By Doctor_H in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-01-2013, 08:03 PM
  3. [SOLVED] Find minimum (ignoring blank cell or zero values) with Multiple Criteria
    By Joeywei in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 05-27-2013, 08:45 PM
  4. How to find minimum sum of row values across multiple columns
    By jaykrao999 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-01-2013, 07:08 AM
  5. [SOLVED] Find the minimum value from a range in multiple columns
    By newbi004 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-14-2013, 12:13 PM
  6. Replies: 11
    Last Post: 01-02-2013, 10:14 AM
  7. find minimum of range based on multiple criteria
    By Weissme in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-21-2006, 12:25 PM

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