let

I am preparing a cashflow model which has a column with years starting at say 2023 going on for several decades. I wish to make a periodic income in the adjacent column that starts in say 2025 then repeats every say 3 years. Could someone help construct a formula for this? The start year, the...

For weeks I've been trying to find a better way to make a Wind Rose Chart or a Spiral Bar Chart to keep track of my Achievements in Steam. I tried to ask AI-aided Formula Editor but it's either not working or I'm not asking the right questions. I'm trying to find a better way to write the...

Hi everyone. Im trying to find the average of the top values of several- non continued ranges. see image for reference: What I need is being able to average the TOP value of range B4:B15 with the TOP (the ones in green) value of B17:28 and so on for the next following cells that are not in...

I am confused why my Custom Column returns a Function instead of lists? Output: = Table.AddColumn(#"Grouped Rows", "Test", each if List.FindText(Text.Split([All Matches], ","), [Email Domain]) <> false then each let EmailDomainVar = [Email Domain] in List.Select(Text.Split([All Matches]...

I want to pull the last 5 quarter data of "Symbol and itemcode" from the table. Symbol and item code" must be transpose. Pulling specific columns by transposing two headers I want to reach an image like the first picture so that I can compare. How can we solve it in the shortest possible way...

I want to pull the last 5 quarter data of "Symbol and itemcode" from the table. Symbol and item code" must be transpose. Pulling specific columns by transposing two headers I want to reach an image like the first picture so that I can compare.

Hello, I have a "LET" formula trying to use, however, i got an error whenever I put a text on the first column. This is use for data validation, so i can remove the unique values and it is based on the data from "Shift" then "Group" headers. Thank you in advance!

Hi all! Hopeful that you can help me speed up some of my formulas. I'm building a chain of LAMBDA functions and the most recent one is running really slowly and I can't figure out why because if I run the exact same formula just filling in the variables, it runs instantly. Details below: Runs...

Hi, I previously received some support on the following link Formula Support - Top 10 list using Index and Match, where i was directed to changing my formula to a LET function. The formula worked fine, but i noticed that it was pulling back multiple values with the same name, Is there anyway...

Hi all, I have another question regarding =LET. I currently use this let formula =LET(Drng,'Sheet1'!$A$1:$A$20,Rng,F2,IF(SUM((Drng<>"")*(ISNUMBER(MATCH("*"&Drng&"*",Rng,0)))), "Y", "N")) This works fine when I fill down. I'm wondering how to change "F2" in this formula to reference the...

Hello, I'd appreciate any thoughts on my question. Was hoping that I can accomplish this without using macros, but open using macros if it's the only way to solve the problem. Here's the scenario: on tab A, I have 3 variables - a, b, and c. The variables will have a unique amount assigned and...

Hello, I'm calculating Split Multiplier column from Split Ratio column by multiplying the rows from the current row towards the end of the column. It works nicely within normal excel table with PRODUCT($B3:INDEX(B:B; ROWS($B$3#)+ROW($B$3)-1) ) where the formula is copied down, but if I try to...