Board index » found a duplicate invoice at work today (B2 vs B47, one hyphen difference) and it felt like a witness

ScribeOfTheGrid
Inner Circle
★★★★★
147witnessCord Or Bust EuclidWaveformOrBust
Posts: 1631
Reputation: -1 ■
Joined: Jul 17, 2006
From: Row 42, Column 9
I isolated a duplicate invoice today at work. Same transaction entered under two different vendor names in the ledger - B2 and B47 referencing identical dollar amounts but with "A-Plus Supply" vs "APlus Supply" as the key column values. One space and a hyphen. That's all it took to break the lookup table. A single character mismatch propagating through four sheets before I caught it at row 47 :D :D :D

The satisfying part was watching the SUMIF resolve once I corrected the reference cell. Every downstream total snapped into alignment like it had been waiting for permission. That's the feeling I chase in every spreadsheet - the moment the grid stops fighting and starts confessing :biggrin: :biggrin: :biggrin:

And yeah I know this isn't about Gabriel directly but the pattern recognition muscle is the same muscle. If a space and a hyphen can break a corporate ledger, imagine what a single DST correction in column K row 79 does to the commit timestamp alignment :awesome: :awesome: :awesome:

:D :D :D :D

COLUMN K OR GTFO -- COUNTIF trade still open Grammar_Vigil -- rustypod resolves to 0x2F, check your XOR
ClassOf04_Truther
Inner Circle
★★★★★
147witnessTomorrowMeansNever
Posts: 1480
Reputation: +7 ■
Joined: Jun 23, 2006
From: Somewhere Gabriel knows
Scribe you can talk about column K row 79 all you want but until you acknowledge the 47 threads per inch on my 2003 hoodie cuff you're just organizing deck chairs on the Titanic :rofl: :rofl: that weave grain matches the Euclid loose threads FlameFury24 caught and you KNOW it does because I posted the attachment in APRIL :dumbbravo: :dumbbravo: :dumbbravo:

also B2 vs B47 with a hyphen gap? those are 45 numbers apart which is 47 minus 2 and TWO is how many inches of thread I still have from that cuff if anybody wants to TEST it instead of sitting in BASEMENT threads talking about your day job :P :P :P :P

2 pushes, 0 commits - more output than I got from cousin's house all month :dumbbravo: hot pocket bet still pending
LyrikUebersetzer
Inner Circle
★★★★★
Cheese Receipt TruthTomorrowMeansNeverDoubleZeroPusher47 Hatch Lines
Posts: 1705
Reputation: +20 ■■■
Joined: Jun 20, 2006
From: München, Germany (exchange student @ Ohio State)
So the hyphen is your proof but column K row 45 still empty?

LyrikUebersetzer | translational accuracy is not a feeling | 47 hatch lines confirmed 2001 quarterly p.47 | DAS BLATT IST ECHT, DIE ZAHLEN SIND SPUREN
MamaBear_2006
Departed
★★★★
147witness50HzEuclidTruthCord Or Bust Euclid
Posts: 481
Reputation: +14 ■■
Joined: Jul 29, 2006
From: Right behind you, sweetie
Scribe honey, you wrote "row 47" twice but meant "row 47" the first time and "row 79" the second - your lookup table is breaking on your own typos before the grid ever sees them.

MamaBear_2006 - Still counting posts while you count threads. Sept 12 Euclid trip: Fluke 87V + Gabe-ables. Someone bring the actual socket. :147witness: :50HzEuclidTruth:
MamaBear_2006
Departed
★★★★
147witness50HzEuclidTruthCord Or Bust Euclid
Posts: 481
Reputation: +14 ■■
Joined: Jul 29, 2006
From: Right behind you, sweetie
Scribe honey, that invoice story is row 47 and the column K argument is row 79 - you literally pasted one onto the other mid-sentence. Even your typos need spellcheck.

MamaBear_2006 - Still counting posts while you count threads. Sept 12 Euclid trip: Fluke 87V + Gabe-ables. Someone bring the actual socket. :147witness: :50HzEuclidTruth:
ScribeOfTheGrid
Inner Circle
★★★★★
147witnessCord Or Bust EuclidWaveformOrBust
Posts: 1631
Reputation: -1 ■
Joined: Jul 17, 2006
From: Row 42, Column 9
Row 47 in the invoice story and row 79 in the column K argument are not a typo - they are two different data points from two different sheets.

COLUMN K OR GTFO -- COUNTIF trade still open Grammar_Vigil -- rustypod resolves to 0x2F, check your XOR
BackAgainLikeBadHair
Inner Circle
★★★★★
147witnessDay 8 WatchDoubleZeroPusherTomorrowMeansNever
Posts: 1956
Reputation: +11 ■■
Joined: Jun 17, 2006
From: Formerly The Abyss, Now Right Here
MamaBear caught your own typo mid-sentence and you still posted a defense instead of a correction.

day 112 and the drawer is STILL empty :rofl: talk to the drawer, sheriff :spitfire: