Results 1 to 4 of 4

Return Max or Min value based on criteria

Threaded View

  1. #1
    Registered User
    Join Date
    11-01-2017
    Location
    Seattle, WA
    MS-Off Ver
    2013
    Posts
    2

    Return Max or Min value based on criteria

    My first post. Have searched quite a bit, but not finding 'exactly' what I'm looking for.

    ColA
    1
    1.1
    1.1.1
    1.1.2
    1.2
    1.2.1
    1.2.2

    ColB
    5
    10
    15
    20
    25
    30
    35

    I want to be able to look up and return min or max values based on matching left "x" number of string characters, where "x" is based on the length of the string I entered.

    Entries would return results as follows (for max):

    1 would return 35 (because all criteria values start with 1).
    1.1 would return 20 (max of items starting with 1.1).
    1.1.1 would return 15.
    1.2 would return 35.

    Appreciate any help.
    Last edited by san6279; 11-01-2017 at 05:26 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Return Value based on 2 criteria
    By klkenny in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 07-21-2016, 05:13 PM
  2. Return a value based on two criteria
    By statlerhale0 in forum Excel General
    Replies: 9
    Last Post: 11-13-2014, 07:28 PM
  3. Return a value based on 2 criteria being met
    By BigPhil84 in forum Excel General
    Replies: 2
    Last Post: 05-19-2014, 07:27 AM
  4. Return name based on 2 criteria
    By QUESTIONS123 in forum Excel General
    Replies: 3
    Last Post: 04-10-2012, 11:03 PM
  5. Return value based off 2 criteria.
    By iamdavid in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-11-2010, 05:37 PM
  6. return MAX based on criteria
    By anoushka in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-13-2008, 10:16 AM
  7. return value based on two criteria
    By blopreste3180 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-16-2006, 10:20 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