Forum Discussion

Brass Contributor

Aug 18, 2023

Solved

Need help to resolve Excel Formula using Let,Take,index,Sort,Unique,HSTACK,MMULT,TOROW,MONTH.

I am trying to add 5 additional columns to the function but can get only a $value: Function : =LET(r,B1:G8,m,6,a,TAKE(r,,1),b,INDEX(r,,2),c,INDEX(r,,3),d,INDEX(r,,4),e,INDEX(r,,5),f,INDEX(r,,...

excel

SergeiBaklan
Sep 07, 2023
Norman_McIlwaine

Thank you. Do I understand correctly that csv62719 is you source file. If to avoid Power Query we copy/paste data from it into the sheet in main file, here by formula create massaged range and based on it and month/year/monthid parameters create aggregated result. Workflow is correct?

Norman_McIlwaine

Brass Contributor

Aug 25, 2023

Norman_McIlwaine Sergei, If I change the date(day) to a 1 The function works great, Is there anyway we can add in a piece of code to perform a unique when the function is finished I have tried several ways to include this into the function but have failed every time. I even wrote a separate piece of code which I got from the You Tube and adapted it to test my data prior to inserting however I get the same results frustration.

Can you please help me Sergei?

SergeiBaklan

Diamond Contributor

Aug 25, 2023

Norman_McIlwaine

Could you please clarify what shall be unique, or, perhaps, you could manually generate desired result? I see now rows which have the same values in all columns, thus formula returns an array as it is.