code logs -> 2009 -> Thu, 28 May 2009< code.20090527.log - code.20090529.log >
--- Log opened Thu May 28 00:00:23 2009
00:45 Reiv [~82d94c4d@Nightstar-29731.dsl.in-addr.zen.co.uk] has joined #Code
01:46 gnolam [lenin@Nightstar-1382.A163.priv.bahnhof.se] has quit [Quit: Z?]
01:58 Reiv [~82d94c4d@Nightstar-29731.dsl.in-addr.zen.co.uk] has quit [Quit: CGI:IRC (EOF)]
02:59 Vornicus-Latens is now known as Vornicus
03:08 Reiv [~82d94c4d@Nightstar-29731.dsl.in-addr.zen.co.uk] has joined #Code
03:30
< Reiv>
Okay, excel question
03:30
< Reiv>
I want to make a sum of everything in a column, provided the text in a companion column is /not/ something.
03:32
< Reiv>
Can I do this without extra columns?
03:44
< Finale>
yes.
03:44
< Finale>
iirc.
03:44
< Finale>
sumif probably.
03:45
< Finale>
or something.
03:45
< Reiv>
handy!
03:46
< Finale>
yeah, I think that's your function.
03:56
< Reiv>
Yep.
03:57
< Finale>
yey
03:57
<@Vornicus>
Yay
03:59 Rhamphoryncus [~rhamph@Nightstar-7168.ed.shawcable.net] has joined #code
04:04 Finale [c0cb88fd@Nightstar-14595.mibbit.com] has quit [Quit: http://www.mibbit.com ajax IRC Client]
04:14 Reiv [~82d94c4d@Nightstar-29731.dsl.in-addr.zen.co.uk] has quit [Quit: CGI:IRC (Ping timeout)]
05:04 crem [~moo@Nightstar-28703.adsl.mgts.by] has quit [Ping Timeout]
05:45 ToxicFrog [~ToxicFrog@Admin.Nightstar.Net] has quit [Ping Timeout]
05:48 ToxicFrog [~ToxicFrog@69.196.168.ns-22635] has joined #code
05:48 mode/#code [+o ToxicFrog] by ChanServ
06:02 Vornicus is now known as Vornicus-Latens
06:02 GeekSoldier_ [~Rob@Nightstar-8573.midstate.ip.cablemo.net] has joined #code
06:02 GeekSoldier [~Rob@Nightstar-8573.midstate.ip.cablemo.net] has quit [Ping Timeout]
06:03 Syloqs-AFH [Syloq@ServicesAdmin.Nightstar.Net] has quit [Connection reset by peer]
06:21 AnnoDomini [AnnoDomini@Nightstar-29429.neoplus.adsl.tpnet.pl] has joined #Code
06:21 mode/#code [+o AnnoDomini] by ChanServ
07:11 Rhamphoryncus [~rhamph@Nightstar-7168.ed.shawcable.net] has quit [Quit: Rhamphoryncus]
07:28 Rhamphoryncus [~rhamph@Nightstar-7168.ed.shawcable.net] has joined #code
07:51 Derakon is now known as Derakon[AFK]
08:40 ToxicFrog [~ToxicFrog@69.196.168.ns-22635] has quit [Connection reset by peer]
08:42 ToxicFrog [~ToxicFrog@Admin.Nightstar.Net] has joined #code
08:42 mode/#code [+o ToxicFrog] by ChanServ
08:54 ToxicFrog [~ToxicFrog@Admin.Nightstar.Net] has quit [Ping Timeout]
08:59 ToxicFrog [~ToxicFrog@Admin.Nightstar.Net] has joined #code
08:59 mode/#code [+o ToxicFrog] by ChanServ
09:01 gnolam [lenin@Nightstar-1382.A163.priv.bahnhof.se] has joined #Code
09:01 mode/#code [+o gnolam] by ChanServ
09:29 Attilla [~The.Attil@Nightstar-9147.cdif.cable.ntl.com] has joined #code
09:30 mode/#code [+o Attilla] by ChanServ
09:53 Attilla [~The.Attil@Nightstar-9147.cdif.cable.ntl.com] has quit [Connection reset by peer]
09:54 Attilla [~The.Attil@Nightstar-9147.cdif.cable.ntl.com] has joined #code
09:54 mode/#code [+o Attilla] by ChanServ
09:55 Attilla [~The.Attil@Nightstar-9147.cdif.cable.ntl.com] has quit [Connection reset by peer]
10:00 Attilla [~The.Attil@Nightstar-9147.cdif.cable.ntl.com] has joined #code
10:00 mode/#code [+o Attilla] by ChanServ
10:08 You're now known as TheWatcher
11:03 AnnoDomini [AnnoDomini@Nightstar-29429.neoplus.adsl.tpnet.pl] has quit [Ping Timeout]
11:05 Attilla [~The.Attil@Nightstar-9147.cdif.cable.ntl.com] has quit [Connection reset by peer]
11:05 Attilla_ [~The.Attil@Nightstar-9147.cdif.cable.ntl.com] has joined #code
11:10 AnnoDomini [AnnoDomini@Nightstar-29678.neoplus.adsl.tpnet.pl] has joined #Code
11:10 mode/#code [+o AnnoDomini] by ChanServ
12:07 Rhamphoryncus [~rhamph@Nightstar-7168.ed.shawcable.net] has quit [Quit: Rhamphoryncus]
12:50 Attilla_ [~The.Attil@Nightstar-9147.cdif.cable.ntl.com] has quit [Quit: <Insert Humorous and/or serious exit message here>]
13:20 gnolam [lenin@Nightstar-1382.A163.priv.bahnhof.se] has quit [Quit: Reboot]
14:06 gnolam [lenin@Nightstar-1382.A163.priv.bahnhof.se] has joined #Code
14:06 mode/#code [+o gnolam] by ChanServ
15:02 Attilla [~The.Attil@Nightstar-9147.cdif.cable.ntl.com] has joined #code
15:15 Attilla [~The.Attil@Nightstar-9147.cdif.cable.ntl.com] has quit [Ping Timeout]
15:32 Attilla [~The.Attil@Nightstar-9147.cdif.cable.ntl.com] has joined #code
15:32 mode/#code [+o Attilla] by ChanServ
16:05 Syloqs_AFH [Syloq@Admin.Nightstar.Net] has joined #code
16:07 Syloqs_AFH is now known as Syloqs-AFH
--- Log closed Thu May 28 16:35:33 2009
--- Log opened Thu May 28 16:53:04 2009
16:53 TheWatcher [~chris@Nightstar-29731.dsl.in-addr.zen.co.uk] has joined #code
16:53 Irssi: #code: Total of 22 nicks [12 ops, 0 halfops, 1 voices, 9 normal]
16:53 mode/#code [+o TheWatcher] by ChanServ
16:53 * TheWatcher seems to have found a linux kernel bug, yey
16:53 Irssi: Join to #code was synced in 54 secs
17:20 Derakon[AFK] is now known as Derakon
17:33 Alek [~omegaboot@Nightstar-29499.dsl.emhril.sbcglobal.net] has quit [Ping Timeout]
17:34 Alek [~omegaboot@Nightstar-29499.dsl.emhril.sbcglobal.net] has joined #code
18:23
<@McMartin>
Do tell
18:31
<@Vornicus-Latens>
Yeah, I want to know too.
19:28 Attilla [~The.Attil@Nightstar-9147.cdif.cable.ntl.com] has quit [Ping Timeout]
19:57
<@Doctor_Nick>
postum
20:05 Rhamphoryncus [~rhamph@Nightstar-7168.ed.shawcable.net] has joined #code
20:14 ToxicFrog [~ToxicFrog@Admin.Nightstar.Net] has quit [Ping Timeout]
20:14 Attilla [~The.Attil@Nightstar-9147.cdif.cable.ntl.com] has joined #code
20:14 mode/#code [+o Attilla] by ChanServ
20:15 ToxicFrog [~ToxicFrog@Admin.Nightstar.Net] has joined #code
20:15 mode/#code [+o ToxicFrog] by ChanServ
20:17
<@TheWatcher>
McM: it seems to be a known but unresolved problem with some VIA SATA controllers
20:17
<@McMartin>
Aha. >_<
20:18
<@TheWatcher>
Under heavy load, or @several_other_situations the ata driver goes clogs-skyward, and renders the drive unreadable
20:31 ToxicFrog [~ToxicFrog@Admin.Nightstar.Net] has quit [Ping Timeout]
20:37 ToxicFrog [~ToxicFrog@Admin.Nightstar.Net] has joined #code
20:37 mode/#code [+o ToxicFrog] by ChanServ
20:40 You're now known as TheWatcher[afk]
21:20 crem [~moo@Nightstar-28703.adsl.mgts.by] has joined #code
21:43 Vornicus-Latens is now known as Vornicus
22:07 ToxicFrog [~ToxicFrog@Admin.Nightstar.Net] has quit [Operation timed out]
22:23 ToxicFrog [~ToxicFrog@Admin.Nightstar.Net] has joined #code
22:23 mode/#code [+o ToxicFrog] by ChanServ
22:49 gnolam [lenin@Nightstar-1382.A163.priv.bahnhof.se] has quit [Quit: Z?]
23:00 You're now known as TheWatcher
23:10 ToxicFrog [~ToxicFrog@Admin.Nightstar.Net] has quit [Operation timed out]
23:12 ToxicFrog [~ToxicFrog@Admin.Nightstar.Net] has joined #code
23:12 mode/#code [+o ToxicFrog] by ChanServ
23:36 Attilla [~The.Attil@Nightstar-9147.cdif.cable.ntl.com] has quit [Ping Timeout]
23:37 Attilla [~The.Attil@Nightstar-9147.cdif.cable.ntl.com] has joined #code
23:37 mode/#code [+o Attilla] by ChanServ
23:49 ToxicFrog [~ToxicFrog@Admin.Nightstar.Net] has quit [Operation timed out]
--- Log closed Fri May 29 00:00:04 2009
code logs -> 2009 -> Thu, 28 May 2009< code.20090527.log - code.20090529.log >