Results 1 to 15 of 15

Finding the lowest value based on multiple text criteria

Threaded View

  1. #1
    Registered User
    Join Date
    05-10-2008
    Posts
    18

    Finding the lowest value based on multiple text criteria

    I am trying to find the lowest value in a data set.

    The data set to be searched is referenced based upon its ID which includes both the Project Name and its Subcode.

    I tried using:

    =MIN(IF($F$2:$F$9="*"&$B2&"*"&$A$2,$G$2:$G$9))

    as an array, but it returns either 0 or - when the correct output should be 9.

    Any help would be greatly appreciated! Thanks in advance!
    Attached Files Attached Files
    Last edited by meherenow9; 09-19-2011 at 01:49 PM.

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