| --- Log opened Mon Oct 04 00:00:56 2021 |
| 00:05 | <&Reiver> | so how do I get xlookup to search for the *biggest* value as opposed to a *specific* value hm |
| 00:06 | < Mahal> | do you know how to google :P |
| 00:06 | < Mahal> | https://exceljet.net/formula/xlookup-date-of-max-value |
| 00:06 | <&McMartin> | instructions unclear, google came back with seven pages of coding bootcamp spam |
| 00:07 | <~Vornicus> | this question is directly answered by the reference documentation |
| 00:07 | <&Reiver> | ... I was hand programming through the power of logic you bastards |
| 00:07 | <&Reiver> | but thank you |
| 00:07 | <~Vornicus> | https://support.microsoft.com/en-us/office/xlookup-function-b7fd680e-6d10-43e6-84f9-88eae8bf5929 |
| 00:07 | <&Reiver> | Though in hindsight I am sorry I should have specified this was thinking aloud~ |
| 00:08 | <&Reiver> | also office 365 can eat a dick |
| 00:08 | <&Reiver> | no named ranges? really? cmon |
| 00:08 | <&Reiver> | (It can use them just not make them, biiiitch) |
| 00:08 | < Mahal> | Uhhh you can absolutely name ranges in 365 excel??? |
| 00:08 | < Mahal> | I've done it?? |
| 00:08 | < Mahal> | https://support.microsoft.com/en-us/office/define-and-use-names-in-formulas-4d0f13ac-53b7-422e-afd2-abd7ff379c64 |
| 00:12 | <&Reiver> | Well pardon me for assuming https://imgur.com/Loq6Ho8 |
| 00:16 | <@macdjord> | ToxicFrog: Your project should be named Fluttershy~ |
| 00:18 | <@macdjord> | (It tames Discord, y'see...) |
| 00:18 | <~Vornicus> | Reiver: rude |
| 00:19 | <~Vornicus> | I didn't even know there was a web version of excel |
| 00:35 | <&Reiver> | Vornicus: It's what I use 95% of the time now because it lets me run my corporate licence |
| 00:35 | <&Reiver> | I have to remote into my PC at the workplace to get the full fat version |
| 00:35 | <&Reiver> | And the subtle lag there is livable but... why would I if I don't have to etc |
| 00:38 | < Mahal> | Reiv, if you're running E3 or E5 licenses, you'll be entitled to also install it _on a home computer_ |
| 00:38 | < Mahal> | Granted you might have DLP issues that prevent local download, but ... |
| 00:38 | < Mahal> | Oh, you didn't specify web version. |
| 00:38 | < Mahal> | (Note: Excel 365 is _not the web version_, because fuck Microsoft completely and their total inability to have naming conventions) |
| 00:43 | <&Reiver> | I am baffled why, of all things to not include in the web version |
| 00:43 | <&Reiver> | You would neglect to include naming ranges |
| 00:43 | <&Reiver> | You let me reference them! |
| 00:43 | <&Reiver> | I thus curse /all/ forms of Office 365 for leaving out the /weirdest/ shit |
| 00:43 | <&Reiver> | I sorta forgive it for making me do conditional formatting the hard way |
| 00:44 | <&Reiver> | It's not great but I get it ec |
| 00:44 | <&Reiver> | *etc |
| 01:01 | <&ToxicFrog> | I think I'm just going to go with Dlique |
| 01:28 | | Vornicus [Vorn@ServerAdministrator.Nightstar.Net] has quit [Connection closed] |
| 04:07 | | Degi [Degi@Nightstar-9im02f.pool.telefonica.de] has quit [Operation timed out] |
| 04:08 | | Degi [Degi@Nightstar-p2a6p1.pool.telefonica.de] has joined #code |
| 05:17 | | abudhabi [abudhabi@Nightstar-rof0lr.adsl.tpnet.pl] has quit [Ping timeout: 121 seconds] |
| 05:18 | | abudhabi [abudhabi@Nightstar-hqruvu.adsl.tpnet.pl] has joined #code |
| 05:51 | | VirusJTG [VirusJTG@Nightstar-b00.oti.104.208.IP] has quit [Connection closed] |
| 05:51 | | VirusJTG [VirusJTG@Nightstar-b00.oti.104.208.IP] has joined #code |
| 05:51 | | mode/#code [+ao VirusJTG VirusJTG] by ChanServ |
| 06:39 | | Vorntastic [uid293981@Nightstar-phvupn.irccloud.com] has joined #code |
| 06:39 | | mode/#code [+qo Vorntastic Vorntastic] by ChanServ |
| 07:58 | | ToxicFrog [ToxicFrog@ServerAdministrator.Nightstar.Net] has quit [Ping timeout: 121 seconds] |
| 08:18 | | Kindamoody[zZz] is now known as Kindamoody |
| 09:59 | <~Vorntastic> | Reiver: a thing occurs during a week if it starts no later than the week ends, and ends no earlier than the week starts |
| 10:02 | <&Reiver> | ah fuck |
| 10:02 | <&Reiver> | I've done that in SQL before |
| 10:02 | <&Reiver> | And yet, one always forgets |
| 10:03 | <&Reiver> | so |
| 10:03 | <&Reiver> | =TEXTJOIN(", ",TRUE,FILTER(Dates!$B$1:$B$998,(Dates!$A$1:$A$998=Chart!C$2)*(Dates!$C$1:$C$998<=Chart!$B4)*(Chart!$B4<=Dates!$D$1:$D$998),"")) |
| 10:03 | <&Reiver> | should be |
| 10:03 | <&Reiver> | =TEXTJOIN(", ",TRUE,FILTER(Dates!$B$1:$B$998,(Dates!$A$1:$A$998>Chart!C$2)*(Dates!$C$1:$C$998<=Chart!$B4)*(Chart!$B4<=Dates!$D$1:$D$998),"")) |
| 10:03 | <&Reiver> | I think? |
| 10:03 | | * Reiver goes tries it, to see if the world explodes |
| 10:04 | <&Reiver> | whoops nope I need to do this when more awake |
| 10:34 | | catalyst [catalyst@Nightstar-ejd4sd.cable.virginm.net] has quit [Ping timeout: 121 seconds] |
| 10:50 | | catalyst [catalyst@Nightstar-ejd4sd.cable.virginm.net] has joined #code |
| 11:25 | | Kizor [a@Nightstar-nfsqa7.yok.fi] has quit [Ping timeout: 121 seconds] |
| 11:40 | | Kizor [a@Nightstar-nfsqa7.yok.fi] has joined #code |
| 11:42 | | Kizor is now known as NSGuest53274 |
| 12:01 | | Kindamoody is now known as Kindamoody|afk |
| 12:07 | | NSGuest53274 [a@Nightstar-nfsqa7.yok.fi] has quit [Ping timeout: 121 seconds] |
| 12:21 | | NSGuest53274 [a@Nightstar-nfsqa7.yok.fi] has joined #code |
| 12:59 | | NSGuest53274 is now known as Kizor |
| 13:29 | | Kizor [a@Nightstar-nfsqa7.yok.fi] has quit [Ping timeout: 121 seconds] |
| 14:05 | | ToxicFrog [ToxicFrog@Nightstar-ke03f7.cpe.distributel.net] has joined #code |
| 14:05 | | mode/#code [+ao ToxicFrog ToxicFrog] by ChanServ |
| 15:05 | | Vornicus [Vorn@ServerAdministrator.Nightstar.Net] has joined #code |
| 15:05 | | mode/#code [+qo Vornicus Vornicus] by ChanServ |
| 16:36 | | VirusJTG [VirusJTG@Nightstar-b00.oti.104.208.IP] has quit [Connection reset by peer] |
| 16:39 | | VirusJTG [VirusJTG@Nightstar-b00.oti.104.208.IP] has joined #code |
| 16:39 | | mode/#code [+ao VirusJTG VirusJTG] by ChanServ |
| 16:47 | | Emmy [Emmy@Nightstar-l49opt.fixed.kpn.net] has joined #code |
| 16:56 | | Vorntastic [uid293981@Nightstar-phvupn.irccloud.com] has quit [[NS] Quit: Connection closed for inactivity] |
| 17:17 | | catalyst_ [catalyst@Nightstar-ejd4sd.cable.virginm.net] has joined #code |
| 17:17 | | catalyst [catalyst@Nightstar-ejd4sd.cable.virginm.net] has quit [Connection closed] |
| 22:10 | | Kindamoody|afk is now known as Kindamoody |
| 23:16 | | Kindamoody is now known as Kindamoody[zZz] |
| 23:25 | | Vornicus [Vorn@ServerAdministrator.Nightstar.Net] has quit [Connection closed] |
| 23:38 | | Emmy [Emmy@Nightstar-l49opt.fixed.kpn.net] has quit [Ping timeout: 121 seconds] |
| --- Log closed Tue Oct 05 00:00:58 2021 |