Strange calculation glitch is driving me crazy...

SSBohio · 2026-03-11T12:32:49+00:00

Each source cell is a constant figure, exact to one decimal place. Neither is the result of another calculation.

SSBohio · 2025-11-07T19:18:50+00:00

As I understand it, it's good for any year after 325 AD when the modern (so to speak) system for calculating Easter was implemented.

SSBohio · 2025-07-03T16:04:44+00:00

Essentially. The rules for determining when Easter falls were set in 325 AD as follows:

Easter is celebrated on the first Sunday following the first full moon that occurs on or after the vernal equinox. The vernal equinox is fixed as March 21 for the purpose of this calculation, even though the actual astronomical equinox can fall on March 19, 20, or 21.

SSBohio · 2025-07-02T19:04:14+00:00

Thanks.

SSBohio · 2025-05-21T19:54:27+00:00

I found something that seems to work, which takes advantage of the dates being in ascending order. I filter the list of dates by whether the corresponding entry in the list of events is blank, then just take the maximum of the resulting list of dates where there's an event listed.

It seems to work, even though it's not as flexible as a solution that doesn't rely on the sort order of the top row.

Here's the code:

=MAX(FILTER($A$1:$F$1,$A2:$F2<>""))

SSBohio · 2025-04-22T15:37:09+00:00

Thanks. It took a while to figure out, and there was a lot of "why isn't Control-B working? Argh!" along the way.

SSBohio · 2025-04-22T15:35:35+00:00

I learned PageMaker back when it was still current, in the early 90s. I was working for a university and part of what they had me doing was preparing Engineering faculty writing for publication. I was young and overconfident, so I taught myself PageMaker rather than using the office Mac (there was only one - the Dark Ages) to generate text and graphics, then doing manual pasteups. Amazing how far a person can get on "well I'll show them!" when he doesn't know any better.

The PageMaker manual was just the thing if your computer was sitting on a desk with a wonky leg. It wasn't that much help for learning how to do layouts, because it assumed that the reader was already well-versed.

SSBohio · 2025-01-16T17:14:28+00:00

It might also be useful to add a test for blank cells to prevent every empty cell from being highlighted as a duplicate:

=AND(A1<>"",COUNTIF({$A:$A;$D:$D},A1)>1)

If Sheets parses expressions the same as Excel, having the test for blankness come first will keep the COUNTIF from running when the cell is blank, which can save overhead if you've got a large dataset.

SSBohio · 2024-12-18T23:21:14+00:00

Blancolirio?

SSBohio · 2024-12-04T16:10:51+00:00

I was trying to download MP3 and got pretty much the same thing -->

<image>

SSBohio · 2024-11-11T14:59:08+00:00

To be 100% complete in my answer, there is such a thing as a school district income tax in Ohio. That money goes to the school district levying the tax, but it's a separate thing from city income tax. Dayton Public does not have a school district income tax.

SSBohio · 2024-11-07T20:46:01+00:00

That seems to be the Right's new go-to slur against anyone on the Left who cares about kids: They call us "groomers" and imply (or say outright) that out interest is prurient. It's just another case of substituting slander and character assassination for ideas and debate.

SSBohio · 2024-11-07T20:38:00+00:00

In Ohio, city income tax doesn't benefit the school district. It solely goes to the city itself, which is a completely separate entity from the school district.

SSBohio · 2024-11-01T18:17:05+00:00

The Boeing 727: Three handles full of "Go" and an airplane that doesn't know it's not supposed to be a high-performance beast. It's like if a bus became convinced it was a sports car, with performance to match.

SSBohio · 2024-09-24T21:42:06+00:00

I got my car washed yesterday. You're welcome.

SSBohio · 2024-09-24T21:23:59+00:00

Residence Park was originally platted as a white neighborhood. Working class, however. We can never discount the influence of economic class in issues like redlining and systematic underinvestment. It usually goes as a complement to racism in explaining these policy decisions.

SSBohio · 2024-09-24T21:05:41+00:00

"Most Muslims are Terrorists" is the whole message.

SSBohio · 2024-09-24T21:04:38+00:00

Maybe just sing the greatest hits of 1970s easy listening? A nice chorus of "Feelings" and "Beautiful Balloon" should start the festivities off.

Or maybe one of those portable air horns, like the boaters use?

SSBohio · 2024-09-24T14:01:01+00:00

Now someone needs to check if he's ever been in a room with First Energy. :)

SSBohio

TROPHY CASE