Search results

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

Because he hadn't read the rules on EF, nor had he read them here. This is solved according to TerryE on EF.

In B8 copied across: =LET(f,FILTER(Schedule!$A$6:$A$16,FILTER(Schedule!$B$6:$P$16,Schedule!$B$3:$P$3=B6)=B7),FILTER(f,f<>$C$3)) Cross-posted: https://www.excelforum.com/excel-general/1429259-populate-names-of-people-running-the-same-course-on-any-given-date.html

Please provide a sample workbook - we can't manipulate pictures. Are you using Excel 365 for this? What is the 'etc.'? We'd need a definitive list of activities to be ignored.

Which version of Excel os this for?

It is, but if tables aren't possible, you can easily limit the range: =IFERROR(VLOOKUP(A2,INDIRECT("'Info"&$H$1&"'!A1:B10000"),2,FALSE),"")

You're welcome.

In B2 copied down: =IFERROR(VLOOKUP(A2,INDIRECT("'Info"&$H$1&"'!A:B"),2,FALSE),"")

Just for anyone whoi's interested, here's a 365 solutuon (won't work in earlier versions): =BYROW(Table1[Column1],LAMBDA(r, LET(ts,TEXTSPLIT(r," "),l,LEN(ts), TEXTJOIN(" ",,FILTER(ts,l=2)))))

That's a shame - it would be very easy in 365.

Which version of Excel are you using?