Search results

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 *...

Workbook? And a reply in the VLOOKUP thread, please. If I don’t get one, I’m out. I’m finding a lack of one extremely discourteous.

Still no response. Why???

Try this: =FILTER($B$5:$F$27,(--LEFT($B$5:$B$27,1)<>1) * (LEN($E$5:$E$27)=18) * (IFERROR(SEARCH("DELIVER TO STATE",$E$5:$E$27),0))) Note yours was missing all the requisite parenthesis.

What about the VLOOKUP thread? https://chandoo.org/forum/threads/vlookup-round-up-to-next-number.58513/ Happy to look, but I really would like some feedback in that other thread, which is still hanging ...

What about the VLOOKUP thread???

Because it's not limiting the search - it's just asking for entries that match the search string plus a space and then one further character - all of the rows have at least this. You could try this: =FILTER($B$5:$E$27,(SEARCH("DELIVER TO STATE",$D$5:$D$27)*ISERROR((SEARCH("%",$D$5:$D$27)))))...

You've started another thread and not even acknowledged the help I offered here. Some feedback for the effort I made on your behalf would have been courteous.

Any use at all???

Or this: =IFNA(IFNA(VLOOKUP(F6,$O$6:$O$17,1,0),LOOKUP(F6,$O$6:$O$17,$O$7:$O$18)),$O$6)

Try this: =IFNA(VLOOKUP(F6,$O$6:$O$17,1,0),LOOKUP(F6,$O$6:$O$17,$O$7:$O$18))

Can you please attach a sample workbook? I suspect the whole number format was in fact a text column, but I'd need to see it to be sure.

Where would you be selecting the date? Where should the results appear? Please manually mock up an example. This sort of 'hot clicking' isn't possible in Excel, but you could have some sort of dependent drop-dwon list instead.

Why can't you create a desensitised copy that shows the problem?

Mynda Treacy is an excellent teacher. Google "power bi mynda treacy".

Perfetto - prego!