« first day (3135 days earlier)
← previous day
next day →
last day (1885 days later) »
Ramhound
12:15 AM
The joys of
"waiting forever to buy something"
gets my Drobo a 500 GB accelerator drive for $60 :-)
3 hours later…
Michael Frank
3:04 AM
Anyone know off the top of their head if you can sort an Excel column by "A-Z, keyword"? Need the keyword at the end of the sorted column.
6 hours later…
Burgi
9:13 AM
morning
djsmiley2k
9:55 AM
/me glares at imagemagick
Y U STOP WORKING.
3 hours later…
rahuldottech
12:57 PM
Hullo
djsmiley2k
1:31 PM
hi @rahuldottech
allquixotic
2:31 PM
onezero.medium.com/…
@Bob omg :O browser tabs are the reason you're so smart, who knew?!
Bob
o_O
Hennes
3:21 PM
@MichaelFrank I am pretty sure that you can
Can sort A-Z, can sort on multiple columns
can probably =right(Cell with sorting stuff, lenght of keyword)
1 hour later…
djsmiley2k
4:32 PM
£36 android tablet, how bad can it be :D
Burgi
i miss the Tesco Hudl
bertieb
Made with only the finest slave labour!
And the most precious of conflict minerals
also, sometimes they explode for no reason
Burgi
i bought two
both are still working and well loved by my parents
the card reader on the one for my dad has broken but they are both still chugging along
bertieb
4:47 PM
Oh yeah, they are coal-powered
(or was that the xkcd-tablet)
Burgi
my mum's gets weird thermal throttling sometimes but she doesn't close any apps
ever
1 hour later…
djsmiley2k
5:55 PM
@Burgi well this is a weird 40% off code
so £70 tablet reduced.
1 hour later…
Nick
7:02 PM
uh, i know this might just be stylesheet loading issue or something, but I really want to show you this.
Nick
7:12 PM
Nick
8:06 PM
Isn't it weird.
Also, equally 'mazing find:
torwuf.com/xkcd-geocities
So, it turns out Geocities is just shutting down this month:
geocities.yahoo.co.jp
Journeyman Geek
0_0
Michael Frank
@Nick I like this one better.
Nick
@MichaelFrank I thought it was an update, but it turns out to be a glitch. I'd like this too.
Michael Frank
@Hennes So I have names of users that have laptops, but for spare laptops they're labelled as spare. I just want them to appear at the end of the list without having to 'zzzSpare' them all
Hennes
8:23 PM
So colum 2 with spare?
Something like this?
name Sort help
John
Alice
Marc with a K
teddie spare Spare
teddie
Mona
Mona spare Spare
Maud
zac
Izzy
spare Spare
=IF( RIGHT(B14,5) = "spare", "Spare", "")
hmm, that messes up the form
Michael Frank
Yea, not keen on a helper column, but I see where you're going.
Hennes
No idea how to do it without a helper column
And I keep adding more and more over time to do things in smaller steps
But the last is becausse I wrote more excels to be used and maintained by others
for once off use I do not care
3 hours later…
bwDraco
11:24 PM
...welp. Time to upgrade my phone to Android 9.0 Pie.
« first day (3135 days earlier)
← previous day
next day →
last day (1885 days later) »
all rooms
Transcript for
Mar
6
Mar '19
7
Mar
8
Root Access
For all you Super Users out there. You have backups, right?
6
computers
technology
join this room
about this room
00:00
06:00
12:00
18:00
all times are UTC
site design / logo © 2024 Stack Exchange Inc;
legal
mobile