Results 1 to 13 of 13

Adjusting a Unique Let Formula to add an additional column/value.

Threaded View

  1. #1
    Forum Contributor
    Join Date
    07-10-2012
    Location
    United States
    MS-Off Ver
    Office 365
    Posts
    461

    Adjusting a Unique Let Formula to add an additional column/value.

    Hello, I am looking to add to this formula.

    In the example, I added a unique customer number, that I want to return also in the Let/Filter formula.

    =LET(b,FILTER(Table1,Table1[DATE]>TODAY()-30),u,UNIQUE(INDEX(b,,1)),s,SORT(HSTACK(u,MAP(u,LAMBDA(x,SUM(N(INDEX(b,,1)=x)))),MAP(u,LAMBDA(x,SUM(N(INDEX(b,,1)=x)*INDEX(b,,4))))),2,-1),s)
    I appreciate any help.

    Thank you,
    Nick
    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. Replies: 2
    Last Post: 04-21-2021, 11:32 PM
  2. [SOLVED] adjusting formula index with count t get last value in column
    By ABDELFATTA in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-13-2020, 12:22 PM
  3. Help with adjusting Index lookup formula to include additional lookup criteria
    By kingofcamden in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-14-2018, 01:04 PM
  4. Adjusting entire column of formulas by adding additional cell reference
    By lukelucky in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-19-2016, 10:19 AM
  5. Adjusting Macro to be more dynamic for additional columns
    By minimacros in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 07-27-2010, 08:19 PM
  6. How to copy formula without column row numbers adjusting?
    By stormracela in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-28-2010, 08:46 PM
  7. Automatically Adjusting a Column with a Formula
    By mellissacook in forum Excel General
    Replies: 5
    Last Post: 04-09-2008, 04:18 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