Search results

No sample workbook attached, so here's a DIY option in the hope that you have Excel 365 (you don't say):

What do you mean by 'neater'? What doesn't it do that you want it to do?

In F8 copied across: =SUMPRODUCT((MONTH($C$3:$C$227)=MONTH($E8))*(YEAR($C$3:$C$227)=YEAR($E8))*($B$3:$B$227=F$2)) If you have 365, there may be a SPILL formula, but you don't say.

If you have 365 2024, in H2 followed by ENTER: =LET(d,TOCOL(B4:B13&"|"&TRANSPOSE(B4:B13)), h,HSTACK(TEXTBEFORE(d,"|"),TEXTAFTER(d,"|")), FILTER(h,INDEX(h,,1)<>INDEX(h,,2))) Or this: =LET(d,TOCOL(B4:B13&"|"&TRANSPOSE(B4:B13)), h,HSTACK(TEXTBEFORE(d,"|"),TEXTAFTER(d,"|"))...

I was going to look at that route, but then got side-tracked by other things! :DD

You're welcome! Please don't forget to hit the LIKE button under my post. Thanks. :DD

First, get rid of ALL of the INDEX MATCH formulae (they are clunky and slow). We'll use 365 functions instead. Next, in D10 copied across: =LET(d,TOCOL(FILTER('RepHunter Contacts - Member #12'!$BI2:.$DW5000,('RepHunter Contacts - Member #12'!$C2:.$C5000=D$2)),1)...

I am not sure that I understand. In the workbook you have an INDEX MATCH formula that lists US states AND overseas territories (Sheet 1) - is this where you want a new formula? And if it is, and you want the states to align with the states as listed in B and C (is this correct?), where should...

Please ... ;)

Which version of Excel are you using? Where should overseas territories be listed?

Please provide the workbook - we cannot manipulate screenshots.

Please feel free to use the LIKE button under our posts.

Threse are things you need to mention at the outset.

I'll assume you have 365. In H3: C In I3: 07/12/2025 In J3 followed by ENTER: =DROP(GROUPBY(HSTACK(B4:B15,C4:C15),HSTACK(D4:D15,E4:E15,F4:F15),SUM,,0,,(B4:B15=H3)*(C4:C15=I3)),,2) AliGW on MS365 Beta Channel (Windows 11) 64 bit HIJKL 2DomainDatePassFailBlocked 3C12/07/2025242 Sheet: Sheet1

You need SUMPRODUCT, not INDEX MATCH MATCH. In C17 copied across and down: =SUMPRODUCT($F$3:$K$12*($F$1:$K$1=$B17)*($D$3:$D$12=C$16))

You can't do calculations based on cell colour. Do the numeric values appear in the cells? You'd need to use values to work out the average and then colour the cell accordingly. Best to attach a sample workbook.

Please attach the workbook.

Not even a 'thank you'??? Mmm ... :confused: I based it on what you showed in post #1. You are now showing very different expectations. Please mock up in the workbook a few rows of expected results, because I really have no clue what you want. But I'll have ONE guess...

Try this: =GROUPBY(A:.A,B:.B,SUM,3,0)

In G8 followed by ENTER: =LET(g,GROUPBY(Sheet1!C2:C14,HSTACK(Sheet1!H2:H14,Sheet1!I2:I14),SUM,,0), IF(D3="",g,FILTER(g,INDEX(g,,1)=D3)))

Doesn't this do what you want? =LET(u,UNIQUE(CG12:CJ1428), GLs,SUBSTITUTE(INDEX(u,,1)&"-"&INDEX(u,,2),"'",""), h,HSTACK(GLs,INDEX(u,,4)), FILTER(h,GLs<>"-"))

Please add 10-15 rows of expected results manually to the results sheet. I do not understanbd what you want to see in column M, nor which of the four columns of times are relevant. Add some explanatory notes next to your expected results.

OK - in the light of this, I shall withdraw from the fray. Forgetting is one thing: completely ignoring requests for feedback is another thing entirely. My time is precious, too. I'll spend it on other things. Good luck.

Assuming you have Excel 365, have a look at this: https://exceljet.net/formulas/income-tax-bracket-calculation#tax-calculation-with-multiple-brackets

Not a reason to leave your helper without any feedback at all - again, a lack of basic courtesy, sadly, especially when you've been prompted multiple times for a comment. Anyway, you are still lacking parenthesis. This: =FILTER($B$5:$F$27,(--LEFT($B$5:$B$27,1)<>1) * LEN($E$5:$E$27)=18 *...