Post 84482 by orekix@pl.smuglo.li
(DIR) More posts by orekix@pl.smuglo.li
(DIR) Post #84245 by BridgeSight@deadinsi.de
2018-09-19T02:41:43Z
0 likes, 0 repeats
@bryan what does that even mean
(DIR) Post #84265 by NestorSpanknho@bofa.lol
2018-09-19T02:43:40Z
0 likes, 0 repeats
@bryan I once wrote a formula in excel that was like 3 characters shy of the character limit for a single cell. Something broke in my brain that day and I've never been the same since.
(DIR) Post #84275 by crushv@letsalllovela.in
2018-09-19T02:44:10.977345Z
0 likes, 0 repeats
@bryan i saw someone write a vba script that does analysis on 500 mb data sets with excel in this format:
(DIR) Post #84285 by crushv@letsalllovela.in
2018-09-19T02:44:34.881196Z
0 likes, 0 repeats
@bryan blew my mind while also making me question their sanity and decision making skillsi wrote my own thing like that in 30 lines of python
(DIR) Post #84287 by virtual@letsalllovela.in
2018-09-19T02:44:40.383418Z
0 likes, 0 repeats
@bryan aaaa
(DIR) Post #84301 by crushv@letsalllovela.in
2018-09-19T02:45:52.787838Z
0 likes, 0 repeats
@bryan needs more regex
(DIR) Post #84363 by orekix@pl.smuglo.li
2018-09-19T02:51:14.659933Z
0 likes, 0 repeats
@bryan @BridgeSight things get "fun" once you start adding dynamic ranges into your functions, Google Sheets also has some basic support for SQL statements too so you can do cool stuff, see this for example=transpose(query(unique(INDIRECT(ADDRESS(1, MATCH(B12, Data!A1:E1, 0), 4, 1, "Data")&":"&ADDRESS(ROWS(Data!A:A), MATCH(B12, Data!A1:E1, 0), 4, 1))), "Select * order by Col1 asc", 1))
(DIR) Post #84482 by orekix@pl.smuglo.li
2018-09-19T02:58:41.258516Z
0 likes, 0 repeats
@bryan @crushv there are VBA add-ins for adding some support for regex, Google Sheets has some support also
(DIR) Post #84615 by BridgeSight@deadinsi.de
2018-09-19T03:13:32Z
0 likes, 0 repeats
@bryan my hed hurt