Search results

You sent me a PM - I will not provide help via PM. Once you have asked the question here, I will help you. Thanks.

Please don’t ask questions via private message - everything needs to be asked here. Thanks!

There's a breakdown in the attached showing what each parameter in the formula returns.

Just shout if you want me to explain anything.

Sorry - try this: =LET(a,A5:A24,b,X2,d,FILTER(D5:V24,a=b),p,FILTER(A5:C24,a=b), fm,BYCOL(d,SUM), x,XLOOKUP(99999999,fm,D3:V3,"",-1), HSTACK(VSTACK(A4:C4,p),VSTACK(FILTER(D3:V3,D3:V3>=x),FILTER(d,D3:V3>=x))))

No worries - feel free to click on LIKE under my post

This, then: =LET(d,D5:V24,p,FILTER(A5:C24,A5:A24=X2), fm,BYCOL(d,SUM), x,XLOOKUP(99999999,fm,D3:V3,"",-1), HSTACK(VSTACK(A4:C4,p),VSTACK(FILTER(D3:V3,D3:V3>=x),FILTER(FILTER(d,D3:V3>=x),A5:A24=X2))))

It does exactly what you asked for in your sample data. Did you actually try it or just look at it and not see MONTH and assume it wasn't right? This bit finds the first column with an entry: x,XLOOKUP(99999999,fm,D3:V3,"",-1), If it's not doing what you want, then you need to provide a...

Seen, but no reply - did it work for you?

Assuming you have 365, try this: =LET(d,D5:V24,p,FILTER(A5:C24,A5:A24=X2), fm,BYCOL(d,SUM), x,XLOOKUP(99999999,fm,D3:V3,"",-1), HSTACK(p,FILTER(FILTER(d,D3:V3>=x),A5:A24=X2)))

There is no sample data in the table, but when you filter the table, the SUBTOTAL will reflect only visible cells. Can't see a problem here.

What's your locale? Here in the UK it converts automatically. You could try Data | Text to Columns > Next > Next > select DMY > Finish. Attach a sample workbook.

You have a column of text items and a column of numbers - is it the numbers you want to generate? If so, this in B1 copied down: =COUNTIF(A$1:A1,A1)

Any good??? Some feedback would be nice ...

Try this: =IF(COUNTIF(Main[[#Headers],[group]]:[@group],[@group])=1,XLOOKUP([@group],Ref[group],Ref[delta from budget]),"")

This works in your workbook: =IF(COUNTIF(A$3:[@group],[@group])=1,XLOOKUP([@group],Ref[group],Ref[delta from budget]),"")

For XLOOKUP: =IF(COUNTIF(A$3:A3,A3)=1,XLOOKUP(A3,$K$13:$K$15,$L$13:$L$15),"")

In B3 copied down: =IF(COUNTIF(A$3:A3,A3)=1,VLOOKUP(A3,$K$13:$L$15,2,0),"")

Here's one of many tutorials online that might help you: https://www.excel-university.com/dependent-drop-downs-with-filter/

Next time, attach a sample workbook, NOT an uneditable picture.

Attach a sample workbook for us to troubleshoot. A small, DESENSITISED section of it will suffice.

You're welcome - feel free to LIKE my solution. :)

It's a formula, not actually code. If you want it explaining, just shout. You're welcome - feel free to hit LIKE under my post.

For example, if you have Excel 2021 or newer, this in H10: =LET(x,INDEX(C54:C69,MATCH($I1,$A54:$A69,0)), IF(ISNUMBER(MATCH(x,{"H","O","L","I","D","A","Y"},0)),"HOLIDAY",x))

Which version of Excel?