Results 1 to 8 of 8

Find MAX value within a subset of a range

Threaded View

  1. #1
    Registered User
    Join Date
    01-04-2019
    Location
    Mountain View, CA
    MS-Off Ver
    Microsoft 365; Excel for Mac 16.64
    Posts
    22

    Find MAX value within a subset of a range

    I have a spreadsheet that contains multiple columns with prices (I have defined the range as "Sale_Prices"). I can determine the lowest price in the Sale_Prices range using the MIN function. I now want to find the highest price in the spreadsheet that is no more than $0.99 higher than the lowest price (essentially, I will need to group the prices into $1 ranges). Any help in writing that formula would be appreciated. I would prefer to avoid array formulas if possible.

    A sample spreadsheet is attached. The data is in the "Raw Data" tab and the formula should go in cell B4 of the "Calcs" tab. Thanks!
    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. Find within a subset of data from -- what approach is best?
    By learning new things in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 08-19-2018, 05:50 AM
  2. Replies: 1
    Last Post: 03-14-2016, 12:31 AM
  3. [SOLVED] Help on Multiple Criteria lookup to find MIN value within subset of data
    By nzxt1234 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-01-2015, 04:15 PM
  4. [SOLVED] defining a range subset based on a primary range for use in Median and Mode functions
    By Araise in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-06-2013, 06:39 PM
  5. Subset a range for array multiplication
    By mpm166 in forum Excel General
    Replies: 5
    Last Post: 04-16-2012, 06:57 PM
  6. Named range - subset
    By jlt199 in forum Excel General
    Replies: 7
    Last Post: 08-17-2010, 08:48 AM
  7. How to enter symbols for subset or element of a subset in Excel?
    By rwcita in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-23-2006, 05:30 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