Recent content by dtlantz
-
OT: The Revenant
Going to see it in a few hours. I've been waiting months to see this movie. -
DC Announcement theory...
What about Tom Matukewicz? Worked with Campbell. Worked under Jerry Kill for ten years. https://en.wikipedia.org/wiki/Tom_Matukewicz -
-
-
CyclonesTVs (Texas Game)
If you find one downtown, let me know! I'll be in town for a wedding and am among the disgruntled...haha. -
-
-
Let's see what's in your fridge
Southern Tier Pumpking, Sam Adams Harvest Pumpkin Ale, Dogfish Head 60 Minute IPA, and Diesel -
Pumpkin beer power rankings
I wasn't a big fan of the Pumking. Had Shipyard Pumpkinhead on draught in Portland, ME last week. It was really good. -
Any Excel/Access geniuses out there?
Ah. The find/replace. I'll keep playing around with it. Thanks for your help! -
Any Excel/Access geniuses out there?
Debit 1 Debit 2 Credit 1 Credit 2 Date Amount John Doe James Doe Exec Est of John Doe 10/16/2013 17866.2 John Doe James Doe Exec Est of John Doe 10/16/2013 3054.6 C/F Peter Doe C/F Peter Doe 4/25/2014 8168.1 Mindy Doe & Gary Smith Joint Mindy Doe TOD 1/15/2014 24423.72 IRA C/F Randy... -
Any Excel/Access geniuses out there?
Let me play around with this. I've never used the ISNUMBER function. The only thing I see is that for Row 2, I'd want a true answer as it is the same last name. I'll get back to you on this. Thanks for the help! -
Any Excel/Access geniuses out there?
I was thinking of "Text to Columns" this morning but the cell isn't set up as "First name, last name" for every cell. So when I convert it to space delimited, the last name could potentially be in the A, B, C, D, or even E cell and each row on down is different. This is driving me crazy! -
Any Excel/Access geniuses out there?
I think I've tried this before...haha. The problem is, I'm not sure it works for my situation. A lot of false positives. Sigh. -
Any Excel/Access geniuses out there?
I'm working on a cashiering spreadsheet and am trying to find a way to exclude funds sent to the same person. For instance, in one row, the debit account (in B2) is "Estate of John Doe" and the credit account (in K2) is "John Doe". I am only interested where funds are being sent to someone else...