+ Reply to Thread
Results 1 to 3 of 3

Offset and Match Formula

  1. #1
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,318

    Offset and Match Formula

    Hello:

    Please refer to attached file.

    I am using below formula to get min value from column P,T,W, etc

    Please Login or Register  to view this content.

    The formula and results of the above are shown in cell B3:D4.

    Now i need the formula in cell B4:D4 to do the same to find the max value from column Q,U,Y, etc.


    Let me know if you have any questions.
    Thanks.
    Riz
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    01-19-2012
    Location
    Barrington, IL
    MS-Off Ver
    Excel 2007/2010
    Posts
    1,213

    Re: Offset and Match Formula

    =ifna(max(offset($o6,0,match(b$2,$p$3:$eg$3,0)+1,30)),0)
    +1 to get to Column Q
    MAX to find the max
    You should hit F5, because chances are I've edited this post at least 5 times.
    Example of Array Formulas
    Quote Originally Posted by Jacc View Post
    Sorry, your description makes no sense. I just made some formula that looks interesting cause I had nothing else to do.
    Click the * below on any post that helped you.

  3. #3
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,318

    Re: Offset and Match Formula

    Hi Speshul:

    Superb, thanks a lot..

    Riz

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Help with Offset and Match formula
    By rizmomin in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-08-2014, 02:21 PM
  2. Help with Offset/Match Formula
    By amartino44 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-24-2013, 07:15 PM
  3. Excel 2007 : OFFSET Match formula need help
    By feno1 in forum Excel General
    Replies: 11
    Last Post: 12-24-2010, 01:20 PM
  4. Index, Match, Offset Formula
    By rhudgins in forum Excel General
    Replies: 2
    Last Post: 06-30-2010, 08:10 AM
  5. [SOLVED] Formula Help With MATCH & OFFSET
    By Joe Gieder in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-03-2005, 12:06 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