Results 1 to 17 of 17

Embedding MAX/MIN in SUMPRODUCT Formula

Threaded View

sjpeters75 Embedding MAX/MIN in... 02-01-2024, 12:55 PM
DJunqueira Re: Embedding MAX/MIN in... 02-01-2024, 08:08 PM
sjpeters75 Re: Embedding MAX/MIN in... 02-02-2024, 07:42 AM
AliGW Re: Embedding MAX/MIN in... 02-02-2024, 07:45 AM
sjpeters75 Re: Embedding MAX/MIN in... 02-02-2024, 08:14 PM
AliGW Re: Embedding MAX/MIN in... 02-03-2024, 02:27 AM
sjpeters75 Re: Embedding MAX/MIN in... 02-03-2024, 10:24 AM
kvsrinivasamurthy Re: Embedding MAX/MIN in... 02-03-2024, 04:36 AM
AliGW Re: Embedding MAX/MIN in... 02-03-2024, 04:39 AM
kvsrinivasamurthy Re: Embedding MAX/MIN in... 02-03-2024, 06:15 AM
sjpeters75 Re: Embedding MAX/MIN in... 02-03-2024, 10:32 AM
AliGW Re: Embedding MAX/MIN in... 02-03-2024, 06:50 AM
kvsrinivasamurthy Re: Embedding MAX/MIN in... 02-03-2024, 07:45 AM
sjpeters75 Re: Embedding MAX/MIN in... 02-03-2024, 10:44 AM
AliGW Re: Embedding MAX/MIN in... 02-03-2024, 10:26 AM
AliGW Re: Embedding MAX/MIN in... 02-03-2024, 10:34 AM
AliGW Re: Embedding MAX/MIN in... 02-03-2024, 10:46 AM
  1. #13
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,710

    Re: Embedding MAX/MIN in SUMPRODUCT Formula

    Formula in O17 can be replaced by this formula so that formula in P17 can be avoided. No dragging of formula.
    Single entry in O17 is sufficient.
    Formula: copy to clipboard
    =LET(Clma,UNIQUE(A17#),clmb,TEXTSPLIT(TEXTJOIN(";",FALSE,BYROW(Clma,LAMBDA(Ro,IF(Ro="","",TEXTJOIN("_",FALSE,BYCOL($B$17:$M$20,LAMBDA(x,SUMIF($A$17:$A$20,Ro,x)))))))),"_",";",FALSE),HSTACK(Clma,clmb))
    Last edited by kvsrinivasamurthy; 02-03-2024 at 07:49 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 6
    Last Post: 05-04-2022, 11:28 AM
  2. Embedding a formula into a cell
    By Jlitterio in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-30-2013, 10:32 AM
  3. Embedding SUMPRODUCT & SUMIF
    By sstyre in forum Excel General
    Replies: 3
    Last Post: 01-19-2012, 05:30 PM
  4. Embedding If Statement into SUMPRODUCT
    By rhudgins in forum Excel General
    Replies: 2
    Last Post: 01-19-2010, 06:35 PM
  5. embedding a formula
    By stephen1000 in forum Excel General
    Replies: 5
    Last Post: 03-10-2009, 08:26 AM
  6. Embedding index function in sumproduct
    By everton9 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-05-2007, 04:23 PM
  7. Embedding a formula
    By sixfivebeastman in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-08-2005, 03:48 PM

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