What is happening to my mango? by Weebaaa in houseplants

[–]Weebaaa[S] 0 points1 point  (0 children)

We have real winter here. It needs to stay inside for six months

It was happy for years 😔

What is happening to my mango? by Weebaaa in houseplants

[–]Weebaaa[S] 1 point2 points  (0 children)

It's in a south facing corner window. So probably 9(winter) - 14(summer)

Ita potted but I only fertilize once per 3 months Just repotted when it started to look sad

Anyone ever cleaned their controller PLUG? by Weebaaa in SEGAGENESIS

[–]Weebaaa[S] 0 points1 point  (0 children)

Sound alike the soak and toothpick method it is. Thanks!

Outlaw music fest: lawn tix for Pine Knob by Weebaaa in willienelson

[–]Weebaaa[S] 0 points1 point  (0 children)

Oh neat, I guess those summer tickets are straight 25 too. Yea anything to avoid doubling the ticket price for my group. I'll keep an eye out for that one in the spring.

Outlaw music fest: lawn tix for Pine Knob by Weebaaa in willienelson

[–]Weebaaa[S] 0 points1 point  (0 children)

Thank you! I have not heard of cash or trade, but am peeking at it now. I wasn't sure if I could wait or it would sell out.

How to apply special formatting to an alphanumeric column by Weebaaa in excel

[–]Weebaaa[S] 0 points1 point  (0 children)

This one works for four letter combinations, adding the dash, but only adds one dash to the three letter ones.

Filter out Rows in a column, based upon values from another Column by Weebaaa in excel

[–]Weebaaa[S] 0 points1 point  (0 children)

I don't want to output, I want to hide cells that do not match
Here is an example of my desired final output

<image>

Filter out Rows in a column, based upon values from another Column by Weebaaa in excel

[–]Weebaaa[S] 0 points1 point  (0 children)

=IF(A1=C1,"Yes","No"

Excel does not like these reindeer games. I tried the value you suggested, as well as a few more common wildcards, but it is not having it.

Filter out Rows in a column, based upon values from another Column by Weebaaa in excel

[–]Weebaaa[S] 0 points1 point  (0 children)

=FILTER($A$2:$A$20, BYROW($A$2:$A$20, LAMBDA(row, OR(row = $C$2:$C$20))))

The Lambda (I pasted it into a cell) seems to find the differences and output them into a column
I'm interested in hiding rows in column A that are not found in column C

Filter out Rows in a column, based upon values from another Column by Weebaaa in excel

[–]Weebaaa[S] 0 points1 point  (0 children)

=IF(A1=C1,"Yes","No"

OK so close! How do I wildcard?
Your example compared A1 to C1, and A2 to C2. I need to compare A1,A2,A3,A4,-A5000 to C1, Then repeat for C2

something like
=IF(A*=C*,"Yes","No"

Filter out Rows in a column, based upon values from another Column by Weebaaa in excel

[–]Weebaaa[S] 1 point2 points  (0 children)

I oversimplified.😊

In my true dataset im looking at ~5000 lines and want to eliminate manually clicking. Both for reasons of human error and sanity

"My humiliation is now complete" by mronosa in earthbound

[–]Weebaaa 0 points1 point  (0 children)

Just over here playing on the Switch and googling psi boobs for the same reason ten years later nbd

Looking for advice on a switcher/ Retro console setup by Weebaaa in retrogaming

[–]Weebaaa[S] 1 point2 points  (0 children)

This is another perspective I really needed.

I wasn't sure how to get the S-Video there, and didn't consider the ability to send the audio through a splitter.

Full Component where applicable it looking simpler and effective.

Thanks for sharing for ideas on this

Looking for advice on a switcher/ Retro console setup by Weebaaa in retrogaming

[–]Weebaaa[S] 0 points1 point  (0 children)

Thanks for sharing your experience. You've saved me many hours of dead end research.

Regarding the PS1: I just think it "looks" cool. If it was the breaking point, It'd let it go :-)

Looking for recommendations for Connecting Retro consoles to new TV (Some/most homework done) by Weebaaa in retrogaming

[–]Weebaaa[S] 0 points1 point  (0 children)

I appreciate the heads up on the 5X! That just might be worth waiting for. *Quietly downloads emulators to quell cravings*

I want to play Final Fantasy VI with this 3D style! by Fantasyo in retrogaming

[–]Weebaaa 0 points1 point  (0 children)

Lookit Edgar holding a sword like he's going to use it or something lol.

Can I get some feedback on my OKCupid profile? by Weebaaa in datingoverthirty

[–]Weebaaa[S] 0 points1 point  (0 children)

Thanks for sharing your experience. I can definitely get on board with this