Search results

SPILL alternative: =SUBSTITUTE(DROP(IFERROR(REDUCE("",D1:D188,LAMBDA(x,y,VSTACK(x,IFERROR(TEXTSPLIT(y,CHAR(10)),"")))),""),1),"and ","")

With Excel 2024 or 365: =TEXTSPLIT(D2,CHAR(10))

Pleae explain the logic of your expected results - I don't get it.

Please attach a sample Excel workbook with yoyur requirements mocked up.

Is this an order or a request? It reads like the former ... You can do this with a formula: =LOWER(A1)

@shili12 I think you need to clarify to make your answer helpful - how do you use them and in what way are they essential?

Sorry - I don't understand the formula, so I can't help further.

Maybe this? =MIN(C6,IF(E2 <= E11, MIN(C6, CEILING(E2 / E9, 1) * C2 + D6), C6) + IF(E2 > E11, MIN(C6, CEILING((E2 - E11) / E9, 1) * C2 + D6), 0)) If that's not what you want, attach a workbook with some expected results mocked up.

OK - you know best. :)

If you don't want the 0 result, use this: =DROP(REDUCE(0,H7:H10,LAMBDA(a,b,VSTACK(TAKE(a,1),a+b))),1)

Sounds like you need lookups, but without some sample data, it's impossible to provide concrete advice.

That's a very vague question, but depending on your Excel version, look at these functions: XLOOKUP VLOOKUP & HLOOKUP INDEX MATCH (MATCH) LOOKUP Tell us which version you are using and provide a sample workbook if you need more assistance.

These work: =SUMPRODUCT((A2:A10=E2)*1) =SUMPRODUCT((A2:A10=F2)*1)

Plenty of real-life situations here (where people are asking for help with VBA and macros): https://chandoo.org/forum/forums/vba-macros/

You're welcome. :)

OK. In column R, please manually enter the results that you are expecting for all cells highlighted in yellow. I am not following your explanation, so still have no idea what they should be instead of what is being returned.

Cross-posted: https://forum.ozgrid.com/forum/index.php?thread/1233821-formula-to-identify-which-teams-and-their-percentage-with-the-highest-of-goals-s/

But does it NEED to work in 2021 as well? I am trying to establish whether I can safely use 365 functions for this. No - 2021 does not have a lot of the functions available in 365.

If any solution must work in 2021, then we can't use 365 functions - is this correct? What errors? Where have you mocked up your expected results? You have given us formulae, but nowhere have you said what their objective is. There is little point in reverse engineering a formula that does not...

Which is the OLDEST version that any solution must work with? Please attach an updated sample workbook.

Which version of Excel are you using?

It's for Excel. If you wanted a GoogleSheets solution, you should have mentioned this in the opening post. Please provide a sample workbook (attached here if it's for Excel, or a link to an editable copy on GoogleDrive if it's for GoogleSheets).

If you have Excel 2021 or newer, get rid of all the manually entered dates in column A and paste this into A2 followed by ENTER: =INT(SEQUENCE(1000,,DATE(2023,8,19),0.25)) Change 1000 to suit however many rows you wish to fill.

@vletm HUMAN NATURE!!! ;)

@vletm You have been a moderator here for a long time - so have I on EF. You should know by now that MANY members fail to read the rules before posting, even if you serve them up on a plate. Not reading the T&Cs is something that we are ALL guilty of in life to some degree or other. I don't...