Results 1 to 5 of 5

IF(AND(SMALL(LARGE Combination Help

Threaded View

  1. 11-30-2016, 06:26 AM #1
    chad328
    chad328 is offline
    Registered User
    Join Date
    09-03-2013
    Location
    Australia
    MS-Off Ver
    Excel 2016
    Posts
    96

    IF(AND(SMALL(LARGE Combination Help

    Hi everyone,

    What I'm trying to do is if a cell in Column A is the lowest & is also the largest in column B then render an answer in column C "Complies,
    For the attached example it would be A2 & B1 so that would render a "Does Not Comply"

    Any help much appreciated.

    Cheers,
    Chad
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Request for Excel formula for two conditions (Large to small, then small to large)
    By nicholascky in forum Excel Formulas & Functions
    Replies: 29
    Last Post: 08-14-2016, 01:16 PM
  2. SMALL/LARGE functions...
    By rachandsouza in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-27-2015, 06:33 AM
  3. [SOLVED] How to avoid Zeros in using LARGE AND SMALL formulas like in =LARGE($E$1:$E$10,A1)
    By omega0010 in forum Excel General
    Replies: 5
    Last Post: 07-19-2015, 11:05 AM
  4. [SOLVED] AVERAGEIFS, LARGE, and SMALL
    By opsanalysis07 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-20-2014, 04:14 PM
  5. [SOLVED] Excel 2007 : Pick next large/small value
    By vonborge in forum Excel General
    Replies: 6
    Last Post: 05-15-2011, 10:08 AM
  6. SMALL and LARGE
    By Tonto in forum Excel General
    Replies: 6
    Last Post: 10-27-2005, 02:05 AM
  7. SMALL/LARGE function
    By Barry Taylor in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-07-2005, 03:47 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1