Results 1 to 13 of 13

MINIF and MAXIF values in range help

Threaded View

  1. #1
    Registered User
    Join Date
    05-02-2020
    Location
    tennessee
    MS-Off Ver
    2019
    Posts
    17

    MINIF and MAXIF values in range help

    i am looking to calculate the max and min value in a range which is both dependent on a text value (long /short) and swaps min max value calculation based on long short direction
    see attached workbook example

    i know the formula should include MAXIF and MINIF formula over a given series of data and conditional statements.

    example file attached in excel 2019 version

    example file includes desired values in cells in column M and N
    comments and clarification saved in cells M16, N16, M18, N18, M20, N20

    Thanks in advance for your help!!
    Attached Files Attached Files
    Last edited by bmaness; 04-29-2023 at 09:41 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Need formula of mutiple condition with mutiple values.
    By max2599 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-09-2021, 05:00 AM
  2. Returning a value based on 3 conditions from mutiple tables
    By Bflare in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-10-2020, 07:37 AM
  3. [SOLVED] Index match with mutiple conditions (?)
    By helloxxx in forum Excel General
    Replies: 34
    Last Post: 07-27-2019, 03:26 AM
  4. [SOLVED] Help with formula and mutiple conditions
    By enhydra in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 11-11-2017, 10:31 AM
  5. [SOLVED] COUNTIF mutiple criteria in a single range, but with mutiple ranges.
    By Janbi in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-19-2016, 06:31 AM
  6. Mutiple SUMIF conditions - help needed please
    By iantix in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-18-2016, 05:03 AM
  7. [SOLVED] Trouble calculating Overtime for Mutiple Rates and Employees [Many Conditions]
    By itsavvy in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-24-2013, 08:48 AM

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