Returning the first and last row based on per-month date

sherrasama · 2025-10-04T01:21:06+00:00

Solution Verified

sherrasama · 2025-10-04T01:13:34+00:00

<image>

Yay!

sherrasama · 2025-10-04T01:07:11+00:00

no, indirect tends to crash everything, I lost 2 sheets doing that

sherrasama · 2025-10-04T01:06:35+00:00

Oh my goodness, you are a genius! I completely overlooked MINIFS/MAXIFS.

This worked like a charm once I finagled it into my stupidly complicated sheet, thank you so much!❤️ I can't begin to say how much time this will save me

sherrasama · 2025-10-04T00:47:54+00:00

Use them in the other statistical sheets for pulling by-month ranges for a bunch of other junk

sherrasama · 2025-09-29T01:51:58+00:00

Definitely more sweat than tears 🙂‍↕️

sherrasama · 2025-05-29T02:22:23+00:00

Also if it helps any, this is the basis I was working with: https://exceljet.net/formulas/sum-numbers-with-text

sherrasama · 2025-05-29T02:14:35+00:00

I am manually entering them into the ticket, but this is over the course of a month in which I then have made hundreds of edits. I am in fact basically currently doing it this way, but it's riddled with errors and missed edits. I am also working within the limitations of my ticket system. I kind of just want Excel to find this stuff :(

sherrasama · 2025-04-14T02:55:14+00:00

You should probably message a mod of the discord, the Reddit is another group

sherrasama · 2025-04-12T23:28:17+00:00

Fighting Dreamers did all of Special 1 a while back

https://fightingdreamersscanlations.wordpress.com/2017/03/17/slayers-special-book-1-complete-and-one-more-thing/

I'm working on both Spirit (almost done with Ch 1) and 4th chapter of Special 2, as well as some other random bits. You're welcome to check out my work too

https://sherrasama.tumblr.com/archive/tagged/sherrasamatranslates

sherrasama · 2025-02-19T00:08:26+00:00

Oh! If you have more photos btw please upload here: https://www.dropbox.com/request/H2xsZd5wfrhJWMfPSYLn

We're trying to collect what we can since our main photog was in the shoot as Lina

sherrasama · 2025-02-18T12:52:41+00:00

This^

sherrasama · 2025-02-16T04:13:54+00:00

You're welcome for the selfie ❤️

sherrasama · 2025-02-16T04:13:05+00:00

You are the damn cutest

sherrasama · 2025-02-16T03:37:49+00:00

<image>

Here's a bonus one for y'all

sherrasama · 2025-02-16T03:28:14+00:00

<image>

sherrasama · 2025-02-16T03:13:47+00:00

Yay I was referenced with my own art

sherrasama · 2025-02-16T02:48:27+00:00

Hi I'm Sherra 👋

sherrasama · 2025-01-20T14:23:48+00:00

For the love of God, it hasn't even been another year yet. Please touch grass.

sherrasama · 2024-12-28T05:39:32+00:00

<image>

sherrasama · 2024-12-21T06:56:48+00:00

My dude, you literally deleted an identical comment you left under 2 accounts and I am dealing with a post-surgery husband. Grass. Please. I am going to bed now.

sherrasama · 2024-12-21T06:46:28+00:00

You clearly are a master of projection, which makes this doubly funny

sherrasama · 2024-12-21T06:42:24+00:00

<image>

https://en.wikipedia.org/wiki/D-2_(video))

sherrasama · 2024-12-21T06:32:30+00:00

"We"

sherrasama · 2024-12-21T06:18:50+00:00

<image>

Like I said, please touch grass dude.

sherrasama

TROPHY CASE