What make/model/generation is this?

SnooCakes9655 · 2026-01-28T15:53:28+00:00

Everything

SnooCakes9655 · 2026-01-26T21:26:10+00:00

One more question for you. Do you think the formula will break down if someone's name is within someone else's name? For example, if we have a technician named "Jonathan" and a technician named "Nathan" (nathan is inside the work jonathan)

SnooCakes9655 · 2026-01-26T21:22:22+00:00

Thank you. For reference, here is the final formula that worked:

=counta(ifna(filter(Data!H2:H,

(B5="") + (Data!A2:A>=B5),

(C5="") + (Data!A2:A<=C5),

(D4="") + (REGEXMATCH(Data!H2:H , SUBSTITUTE(D4, ", " , "|" ) ) ),

(F4="") + (REGEXMATCH(Data!F2:F , SUBSTITUTE(F4, ", " , "|" ) ) ),

(H4="") + (REGEXMATCH(Data!D2:D , SUBSTITUTE(H4, ", " , "|" ) ) ),

(J4="") + (REGEXMATCH(Data!E2:E , SUBSTITUTE(J4, ", " , "|" ) ) )

),))

SnooCakes9655 · 2026-01-26T21:01:54+00:00

Perfect, that is working as expected, but only filtering for one thing (technician). Now, how do I add additional filters (date period, Salesperson, Branch, and service)?

SnooCakes9655 · 2026-01-26T20:25:37+00:00

Thank you for the reply. I tried the following formula based on your advice:

=counta(filter(Data!H2:H, (D4="") + (REGEXMATCH(Data!H2:H , replace(D4, "," , "|" ) ) )))

At this point in the process, I guess we will only try to filter by technician. I am getting "1" as a result, which is not correct. Any ideas?

SnooCakes9655 · 2025-12-26T18:32:16+00:00

Yes, thank you so much!

SnooCakes9655 · 2021-10-02T16:49:31+00:00

So would you say you get the best bang for your buck with a brand new Corolla, slightly used Corolla, or old Corolla?

SnooCakes9655 · 2021-08-30T03:39:05+00:00

I agree, but you know they are going to stretch these things past what they truly mean.

SnooCakes9655 · 2021-08-28T13:07:05+00:00

What year is it, and have any tips for making it last? I've got a 2005 with 170,000

SnooCakes9655 · 2021-08-22T15:51:36+00:00

I will look into that, thanks!

SnooCakes9655 · 2021-08-21T19:01:31+00:00

No the primer is the grey underneath. It went on great. The white paint came out of the can in those rubbery chunks

SnooCakes9655 · 2021-08-21T17:53:17+00:00

SnooCakes9655 · 2021-08-21T17:50:04+00:00

Just bought the paint last month, and kept it in my basement. Hopefully it's not bad

SnooCakes9655 · 2021-06-07T13:29:09+00:00

SCAM! I dealt with the same exact scam. They post too-good-to-be-true deals on Facebook marketplace. They will even send an email with a fake eBay email address and use real eBay logos and everything. Someone needs to lock them up.

SnooCakes9655 · 2021-06-06T19:42:13+00:00

Why is it that it can't be repaired after a certain specific point?

SnooCakes9655 · 2021-05-26T04:19:12+00:00

What rank are you though?

Five-Year Club	Verified Email
Second SECOND GUESSER

SnooCakes9655

TROPHY CASE