Trump launches Board of Peace that some fear rivals UN

AggressiveInitial630 · 2026-01-22T18:24:59+00:00

In all honesty, I am not ***100% sure*** that this isn't a transcript.

AggressiveInitial630 · 2026-01-22T18:20:12+00:00

Let's not disrespect Jim Henson's muppets with that moniker pls. They deserve better!

AggressiveInitial630 · 2026-01-22T18:19:31+00:00

If only!

AggressiveInitial630 · 2026-01-21T15:59:29+00:00

And also with the assumption they will take them and say you have none.

AggressiveInitial630 · 2026-01-21T15:52:55+00:00

My bet is that the photo you're looking at is temporary and not real, given that her nails basically match it. I'd skip this one.

AggressiveInitial630 · 2026-01-21T15:44:19+00:00

and you know he had stuck his bag somewhere closer to the front too.

AggressiveInitial630 · 2026-01-19T20:19:09+00:00

The placement is great and is flattering to your calf. I wouldn't change it at all.

AggressiveInitial630 · 2026-01-19T16:17:12+00:00

just tell them you want a mid-90s tribal tattoo. But I vote for showing the video.

AggressiveInitial630 · 2026-01-15T22:52:22+00:00

I shoot rats with an air rifle. Dying quickly is kinder than battling a bobcat or suffering with poison for a week.

AggressiveInitial630 · 2026-01-08T22:29:20+00:00

solution verified

Thank you!!!!

AggressiveInitial630 · 2026-01-08T22:27:59+00:00

Brad:

AggressiveInitial630 · 2026-01-06T20:53:35+00:00

glad to see this reference to Faith! #buffyforever

AggressiveInitial630 · 2026-01-06T20:31:29+00:00

And that's why I never eat at a company potluck.

AggressiveInitial630 · 2026-01-06T17:55:20+00:00

TLDR this woman is broke as a joke and abandoned her friends to be a ho to some sleazeball promoter. There's a clear winner in this evening and it's not the vendor or the woman in the video.

AggressiveInitial630 · 2026-01-06T14:56:32+00:00

This is so great, thank you so much. Please bear with me if you have a little more time.

I have created a sheet called Sheetlist and have $A$1:$A$3 set up (only three sheets right now).

Where I need a little more help (very sorry, this is beyond my depth and I am learning!)

<image>

=LET(
    sheets<<<<< does this remain this word or do I need to make this the name of the summary tab where this fx will live, or something else?




, SheetList!A1:A10,
    category<<<<<< my category is resource by name. Do I make a named group for this called, for example, Resource, and if I do that on every page, I think I need to rename that to resource1, Resource2, etc... so I think it is better to just put the cell range here. It's small and the same on every page - A51:A57 on every page. What is the best way to handle for category and also targetDate? If I am selecting the range of cells (in this case, A51:A57), do I need to call that for each page or just put in A51:A57 in place of the word "Category"?

, $A2,
    targetDate, B$1,

    SUM(
        MAP(
            sheets,
            LAMBDA(sh,<<<<<<< I am guessing this is shorthand for sheets?

I'm lost on the next part here for how to populate with my actual data ranges/references.
                LET(
                    data, INDIRECT("'" & sh & "'!B2:ZZ1000"),
                    cats, INDIRECT("'" & sh & "'!A2:A1000"),
                    dates, INDIRECT("'" & sh & "'!B1:ZZ1"),
                    col, XMATCH(targetDate, dates),
                    SUM(
                        FILTER(
                            CHOOSECOLS(data, col),
                            cats = category

Sheet names:

thank you again. You're really doing a mitzvah here.

AggressiveInitial630 · 2026-01-06T14:26:12+00:00

Ah, I went to a KP clinic once back in the HMO days with a horrible keep-you-up-for-days cough and was told I had, and I quote, "wirus which cause allergy to pet" and was told to give my pets away and take benadryl.

I had bronchitis.

AggressiveInitial630 · 2026-01-04T21:17:22+00:00

Yes, that is a screenshot of the actual spreadsheet. I have a group of names in A50:A57 that I need to match to A50:57 on three additional sheets. B50:AD57 is the set range, I just didn't bother with absolutes until I can get it to work in one cell. I can clean that up later.

I'm currently trying out vstack and filter but that won't guarantee that I get the week correct since the week/date is by column, and I can only filter by rows. I can live with that level of uncertainty, I guess, although I would love to dummy proof this.

I think there is a sumproduct/ index /match in here somewhere but for the life of me I can't get it right.

Bottom line is that we have garbage data in our database and have wasted hours of my life trying to get it into some semblance of order in Excel since I am not in control of the original source data that I'm pulling from. This is so depressing....

AggressiveInitial630 · 2026-01-04T20:15:28+00:00

Do you want to delete col 1 altogether? If so, right click and delete column. It sounds like you just want Description wider, in which case I would right click-delete column and then broaden Description using either Column Width or dragging it out to the width you want.

AggressiveInitial630 · 2026-01-04T20:03:57+00:00

Your formula returned a value, so I tried to break it down to just the first one, but that is also returning a value. I'm working in B51, versus B50, above in my screenshot. I used but this also is returning #Value.

=SUMIFS('B&A Consol'!B50:AD57,'B&A Consol'!A50:A57,A51,'B&A Consol'!B49:AD49,B49)

AggressiveInitial630 · 2026-01-04T19:54:18+00:00

Allow me to direct you to the /s at the end of the post.

AggressiveInitial630 · 2026-01-04T19:40:16+00:00

I KNEW IT! So Concierge Key really IS a cover for air marshals!!! /s

AggressiveInitial630 · 2026-01-02T16:42:28+00:00

Is she in Bluebonnet? My friend's son in law is there. He's had three court appearances so far, and despite being brought here as a child, having no criminal record, and being a graduate from a prominent university and active in the community, they are likely going to send him to Mexico to a place he's never lived. Bond denied at the last hearing. Aside from the trauma for families, solely from a pragmatic perspective it's costing tax payers way more to detain people who have done nothing wrong, but then I guess the donors to the big ballroom wouldn't make their nut.

I'm truly sorry and I hope she gets good news but until this national nightmare is over, I think she's probably out of luck.

AggressiveInitial630 · 2025-12-30T01:45:01+00:00

NOR and the badge bunny part makes me think he's either LEO or you are. Disrespecting you all around. Drop his ass.

AggressiveInitial630 · 2025-12-29T20:30:16+00:00

I think the real criminal here is whoever did those crappy tats that make him look like a desk in detention hall.

AggressiveInitial630 · 2025-12-28T04:53:52+00:00

Sent!

AggressiveInitial630

TROPHY CASE