« first day (3135 days earlier)      last day (1885 days later) » 

12:15 AM
The joys of "waiting forever to buy something" gets my Drobo a 500 GB accelerator drive for $60 :-)
 
 
3 hours later…
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…
9:13 AM
morning
 
9:55 AM
/me glares at imagemagick
Y U STOP WORKING.
 
 
3 hours later…
12:57 PM
Hullo
 
1:31 PM
hi @rahuldottech
 
2:31 PM
onezero.medium.com/… @Bob omg :O browser tabs are the reason you're so smart, who knew?!
 
Bob
o_O
 
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…
4:32 PM
£36 android tablet, how bad can it be :D
 
i miss the Tesco Hudl
 
Made with only the finest slave labour!
And the most precious of conflict minerals
also, sometimes they explode for no reason
 
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
 
4:47 PM
Oh yeah, they are coal-powered
(or was that the xkcd-tablet)
 
my mum's gets weird thermal throttling sometimes but she doesn't close any apps
ever
 
 
1 hour later…
5:55 PM
@Burgi well this is a weird 40% off code
so £70 tablet reduced.
 
 
1 hour later…
7:02 PM
uh, i know this might just be stylesheet loading issue or something, but I really want to show you this.
 
7:12 PM
 
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
 
@Nick I like this one better.
 
@MichaelFrank I thought it was an update, but it turns out to be a glitch. I'd like this too.
 
@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
 
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
 
Yea, not keen on a helper column, but I see where you're going.
 
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…
11:24 PM
...welp. Time to upgrade my phone to Android 9.0 Pie.
 

« first day (3135 days earlier)      last day (1885 days later) »