Search found 29255 matches
Re: Excel
Yeah, I don't like the count in the same column.
Re: Excel
You want COUNTIF. If that data is in column A, its ... =COUNTIF(A:A,"Administration")
Re: Excel
If I'm understanding it right that those 4 categories above are a column and then amount is a column, it sounds like you want to use SUMIFS.
Re: Excel
Yeah I need a screenshot or something to understand this one.
- Fri Apr 05, 2024 10:44 am
- Forum: The Swamp
- Topic: Holy fuck we just had an earthquake
- Replies: 54
- Views: 2233
Re: Holy fuck we just had an earthquake
Yeah, I'm surprised anyone here who didn't. This was like "whoa shit" then everyone goes on their porch to see if neighbors felt it too.
- Fri Apr 05, 2024 10:20 am
- Forum: The Swamp
- Topic: Holy fuck we just had an earthquake
- Replies: 54
- Views: 2233
Re: Holy fuck we just had an earthquake
Probably his hand, the sick freak.
Shutting down the Holland for precautionary inspection but not the Lincoln kinda feels like maybe its not just precautionary?
Shutting down the Holland for precautionary inspection but not the Lincoln kinda feels like maybe its not just precautionary?
- Fri Apr 05, 2024 9:36 am
- Forum: The Swamp
- Topic: Holy fuck we just had an earthquake
- Replies: 54
- Views: 2233
Re: Holy fuck we just had an earthquake
Lebanon NJ has it at 4.8 which, when you factor in east coast bias, is the biggest earthquake in US history.
- Fri Apr 05, 2024 9:30 am
- Forum: The Swamp
- Topic: Holy fuck we just had an earthquake
- Replies: 54
- Views: 2233
Re: Holy fuck we just had an earthquake
Its a massive range. So far I've heard Poughkeepsie through west of Philadelphia.
- Thu Apr 04, 2024 8:14 pm
- Forum: The Swamp
- Topic: NCAA Basketball 23-24
- Replies: 628
- Views: 32417
Re: NCAA Basketball 23-24
SHUT DOWN SOUTH ORANGE AVE BABY WE’RE THROWING A FUCKING PARADE WOOOOOOO!!!
- Thu Apr 04, 2024 4:59 pm
- Forum: The Swamp
- Topic: EPL 2023-24
- Replies: 400
- Views: 15002
Re: EPL 2023-24
I don't understand that last goal in terms of how much space he was given.
- Thu Apr 04, 2024 1:41 pm
- Forum: The Swamp
- Topic: The Baltimore Key Bridge collapse on 695
- Replies: 92
- Views: 8264
Re: The Baltimore Key Bridge collapse on 695
All of this plus the McConnell in-law story definitely caused my dream last night. I woke up not quite sure where I was so I looked at google maps on my phone and I was in SE Brooklyn which was a newly developing beachfront area and def not real Brooklyn. I left the apartment I was in, found my car ...
- Thu Apr 04, 2024 1:34 pm
- Forum: The Swamp
- Topic: The Earthquake Thread
- Replies: 27
- Views: 846
Re: The Earthquake Thread
That near miss in the white car at the end is ... something.
- Thu Apr 04, 2024 1:32 pm
- Forum: The Swamp
- Topic: NFL 2024 Offseason
- Replies: 319
- Views: 17128
Re: NFL 2024 Offseason
British prospect?
- Thu Apr 04, 2024 11:23 am
- Forum: The Swamp
- Topic: NFL 2024 Offseason
- Replies: 319
- Views: 17128
Re: NFL 2024 Offseason
I'd like to read more about this draft class ...
- Thu Apr 04, 2024 11:02 am
- Forum: The Swamp
- Topic: NCAA Basketball 23-24
- Replies: 628
- Views: 32417
Re: NCAA Basketball 23-24
I get its not the same 12-15 guys but I also don't see much harm, especially given there's like a 0% chance they'd end up being worse than a lot of the low major auto-bids? Unless we just want to say no one should give a shit about the NIT either way, which is equally valid. I live walking distance ...
- Thu Apr 04, 2024 10:08 am
- Forum: The Swamp
- Topic: NCAA Basketball 23-24
- Replies: 628
- Views: 32417
Re: NCAA Basketball 23-24
Because there's no rule saying present year can't affect subsequent year? European kickball tournaments do it all the time.
Re: MLB 2024
They might want to do something pretty quickly given they're on pace to finish 30+ games out of 1st in the East.
- Thu Apr 04, 2024 9:26 am
- Forum: The Swamp
- Topic: NCAA Basketball 23-24
- Replies: 628
- Views: 32417
Re: NCAA Basketball 23-24
I don't know how closely the tournaments all work together, but if they set the NIT as an autobid for next year it would probably stop teams from backing out or not caring.
- Wed Apr 03, 2024 9:30 pm
- Forum: The Swamp
- Topic: Presidential Election 2024
- Replies: 536
- Views: 15634
Re: Presidential Election 2024
But what if, hypothetically, a president was actively “sprinkling fairy dust” (supplying an endless arsenal of weapons) that were being used to kill thousands and thousands of children? Couldn’t they just stop “sprinkling fairy dust” (supplying an endless arsenal of weapons)?
- Wed Apr 03, 2024 9:17 pm
- Forum: The Swamp
- Topic: 2023-2024 NHL Season
- Replies: 657
- Views: 28219
Re: 2023-2024 NHL Season
Nah, we would have kept Miller if anyone. More than Vesey doesn’t fight and maybe thought his best chance was diving right in.
You can definitely skate away if the other guy drops, but Rempe couldn’t. He had to answer for a lot there.
You can definitely skate away if the other guy drops, but Rempe couldn’t. He had to answer for a lot there.
- Wed Apr 03, 2024 7:29 pm
- Forum: The Swamp
- Topic: 2023-2024 NHL Season
- Replies: 657
- Views: 28219
Re: 2023-2024 NHL Season
Without knowing the answer, NJ has a lot more to yell at NYR about than vice versa. Rempe deserves to get the shit kicked out of him by then and then some. And if Vesey wasn’t responsible for the line brawl, he knew it was coming and clearly tried to get a jump.
- Wed Apr 03, 2024 7:26 pm
- Forum: The Swamp
- Topic: Presidential Election 2024
- Replies: 536
- Views: 15634
Re: Presidential Election 2024
Would you say Biden cares about Palestinian kids?
- Wed Apr 03, 2024 7:15 pm
- Forum: The Swamp
- Topic: 2023-2024 NHL Season
- Replies: 657
- Views: 28219
Re: 2023-2024 NHL Season
Rempe and Marino are both lucky they still have their full faces. Rangers losing their two worst Fs and a badly struggling Trouba isn’t the worst thing but 4 D for 59:58 isn’t great.
(And Cuylle easily could have gotten more for his boarding. Deserved the punches he ate.)
(And Cuylle easily could have gotten more for his boarding. Deserved the punches he ate.)
- Wed Apr 03, 2024 5:12 pm
- Forum: The Swamp
- Topic: Presidential Election 2024
- Replies: 536
- Views: 15634
Re: Presidential Election 2024
I think we have very different baselines for the standard.
- Wed Apr 03, 2024 4:57 pm
- Forum: The Swamp
- Topic: Presidential Election 2024
- Replies: 536
- Views: 15634
Re: Presidential Election 2024
If a year ago everyone here saw that exact sentence with the name of the president redacted, not a single person here would guess Biden over Trump.
- Wed Apr 03, 2024 4:29 pm
- Forum: The Swamp
- Topic: Presidential Election 2024
- Replies: 536
- Views: 15634
- Wed Apr 03, 2024 2:50 pm
- Forum: The Swamp
- Topic: Worthy of mention, too obscure for own thread
- Replies: 3889
- Views: 235817
Re: Worthy of mention, too obscure for own thread
Going to admit I had no idea who Joe Flaherty was until I saw a reference to Happy Gilmore. That role always seemed like "what if Rob Schneider were funny". https://img.bleacherreport.net/img/slides/photos/003/374/238/ScreenShot2013-09-27at7.59.28PM_crop_exact.png?w=2975&h=2048&q=85
- Wed Apr 03, 2024 2:43 pm
- Forum: The Swamp
- Topic: EPL 2023-24
- Replies: 400
- Views: 15002
Re: EPL 2023-24
Jhoan Duran and Jhon Duran should have to switch sports for a weekend.
- Wed Apr 03, 2024 2:11 pm
- Forum: The Swamp
- Topic: Getting the spins
- Replies: 3317
- Views: 215463
Re: Getting the spins
"Stick to being a rap singer!"
- Wed Apr 03, 2024 1:56 pm
- Forum: The Swamp
- Topic: EPL 2023-24
- Replies: 400
- Views: 15002
Re: EPL 2023-24
Not sure if they've done this before and I've missed it (or posted here and forgotten, Rass), but this is cool:
- Wed Apr 03, 2024 11:35 am
- Forum: The Swamp
- Topic: Getting the spins
- Replies: 3317
- Views: 215463
Re: Getting the spins
Its on now and I think it kinda sucks shit?
- Tue Apr 02, 2024 10:21 pm
- Forum: The Swamp
- Topic: Presidential Election 2024
- Replies: 536
- Views: 15634
- Tue Apr 02, 2024 4:16 pm
- Forum: The Swamp
- Topic: April Fools pranks (successful and otherwise)
- Replies: 70
- Views: 3748
- Tue Apr 02, 2024 4:15 pm
- Forum: The Swamp
- Topic: The Live Music thread...
- Replies: 2118
- Views: 180751
Re: The Live Music thread...
He'd probably make money opening for Drake too, but I mean more like how does that connection even happen?
- Tue Apr 02, 2024 4:14 pm
- Forum: The Swamp
- Topic: Television (no longer temporary)
- Replies: 6259
- Views: 368082
Re: Television (no longer temporary)
Calling someone who isn't Chris Cosentino this is like referring to Larry Nance Jr. as "the Akron basketball dude".govmentchedda wrote: ↑Sun Mar 31, 2024 11:05 amThe S.F. offal dude, who went out first, choosing to not stay for last chance kitchen seems like a bit of a moron.
- Tue Apr 02, 2024 3:21 pm
- Forum: The Swamp
- Topic: The Live Music thread...
- Replies: 2118
- Views: 180751
Re: The Live Music thread...
Why is Father John Misty touring as support for Kacey Musgraves?
Re: MLB 2024
Ha ha ha I thought the Astros players had to promise to stop banging ha ha ha!!!
- Mon Apr 01, 2024 9:24 pm
- Forum: The Swamp
- Topic: 2023-2024 NHL Season
- Replies: 657
- Views: 28219
Re: 2023-2024 NHL Season
The worst part of these Knicks and Rangers seasons is I really felt like Dolan might be getting ready to sell.
(The best part is all the winning.)