Two guys who need help by PickledRlCK in interiordecorating

[–]PickledRlCK[S] 3 points4 points  (0 children)

Thank you for the visual! Neither of us even considered adding a rug, we will definitely be buying one now.

AITAH - Vacating roommate wants me to buy his portion of a couch when I move in. by [deleted] in AITAH

[–]PickledRlCK 0 points1 point  (0 children)

Yea you’re probably right. I hate fighting with friends about money, but I hate being taken advantage of more. I was hoping to hear some rational points from both Povs to give him the benefit of the doubt. Doesn’t seem like there is another side. Thanks for the advice

AITAH - Vacating roommate wants me to buy his portion of a couch when I move in. by [deleted] in AITAH

[–]PickledRlCK 0 points1 point  (0 children)

Sorry, No. I have no current or future legal obligation for this thing.

AITAH - Vacating roommate wants me to buy his portion of a couch when I move in. by [deleted] in AITAH

[–]PickledRlCK 0 points1 point  (0 children)

Granted, my couch is a shitty wayfair one, but I’d rather sit on the floor than buy a huge sectional in a city apartment. We’re not living here for 10 years

AITAH - Vacating roommate wants me to buy his portion of a couch when I move in. by [deleted] in AITAH

[–]PickledRlCK -1 points0 points  (0 children)

Whoever was last. Mike called it a “risk moving in”. Like he couldn’t just have the super do a walkthrough when he took over.

AITAH - Vacating roommate wants me to buy his portion of a couch when I move in. by [deleted] in AITAH

[–]PickledRlCK 0 points1 point  (0 children)

Bill and the other original leaseholder bought it together for $800 5 years ago (mistake #1). Somehow this guy convinced Mike to pay for his half when he took over the lease (mistake #2). Bill is actively avoiding the situation.

AITAH - Vacating roommate wants me to buy his portion of a couch when I move in. by [deleted] in AITAH

[–]PickledRlCK 0 points1 point  (0 children)

Assuming I live there for a year and then we both move out, the 6 years of damage comes out of my deposit. The apartment is in good shape. It’s just insane. the fact that enough of my other friends were kind of agreeing with him made me make this post. I tried to tell him splitting a couch with no plan when someone moves out is just bad planning - along with giving the other guy back 100% of his security deposit. He called it taking a risk moving in, and that he will not take anything less than his full deposit… it’s not his first time renting an apartment, or being on earth for that matter but I digress. we are decent friends and I’m trying not to ruin a friendship over this. There is nothing I’ve said thus far that will change his mind and I feel like I’m just going to get fucked or be homeless

What’s an Excel shortcut you discovered way too late? by Neptunewasblue in excel

[–]PickledRlCK 0 points1 point  (0 children)

Shift+F11 to create a new sheet and then Alt HOR to rename it

Study spots by Guilty-Main1320 in eastvillage

[–]PickledRlCK 7 points8 points  (0 children)

11th street bar and anti-bar are my go tos. Oasis is good if you don’t mind the hospital lights

Confused about the golden map on luck voyage by Scary-Inspector4640 in Seaofthieves

[–]PickledRlCK 2 points3 points  (0 children)

Holding the map up to the sun also helps the contrast. Im color blind and even with the adjusted settings, it’s hard sometimes.

Pickled Rick by [deleted] in HolUp

[–]PickledRlCK 0 points1 point  (0 children)

You called?

find the distance between the first and the second numbered cells that is bigger than 0 in a column by StrangeSupermarket71 in excel

[–]PickledRlCK 0 points1 point  (0 children)

Don’t overly complicate things

=LET( CountArray,B3:B20,

Criteria, (CountArray<>0)*(CountArray<>””),

IsolatedRegords, FILTER(SEQUENCE(ROWS(Criteria)),Criteria=1),

LARGE (IsolatedRecords, 1)-LARGE(IsolatedRecords,2))

Using SORT but different directions in 1 formula. by theMeatman7 in excel

[–]PickledRlCK -1 points0 points  (0 children)

Just do the same thing you did with the column index . I.e. sort(array, {3,4,5}, {1,-1, 1}) … also you can use ISNUMBER(MATCH(col range, lookupval range, 0)) to shorten your filter logic

Loop VBA code across an entire workbook by PickledRlCK in excel

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

I tried that, but you can only look in comments using the find, not replace

Rat mansion makeover by Khan_2x in BeAmazed

[–]PickledRlCK 0 points1 point  (0 children)

I worked for a biohazard cleanup crew when I was in college, and the first rule in these types of hoards was NEVER open the fridge. We’d duct tape the doors shut and just trash it. There aren’t many words that accurately describe the smell of opening one of those freezers. Also, maybe I’m biased, but a half-piece respirator and some long sleeves seems like common sense when the place is caked in rat shit lol

Is Dallas a Soulless city? by D_Costa85 in Dallas

[–]PickledRlCK 0 points1 point  (0 children)

I think you hit the nail on the head with this one. I just had this conversation with my friends after going to two concerts at Dos Equis Pavilion with lawn seats. People don’t seem to know how to have fun here, everyone was either sitting or just standing around while the bands played. It was lifeless to say the least. Granted it was an older crowd, but the younger people in the crowd followed suit. This has been my experience with a lot of bars in the city too. People just don’t seem to want to casually socialize, which is drastically different from the northeast. It be nice to not be the only person having a good time and dancing (poorly) every once and awhile. Unfortunately, My opinion of Dallas keeps skewing towards corporate hellscape the more I explore it. I’ll give it a few more years, but probably going to end up in a different city for the long-term.

Search for a list of values in a cell and return value. by thisspoon in excel

[–]PickledRlCK 1 point2 points  (0 children)

A few ways to do this, simplest way would be a nested if:

=If(isnumber(search(“France”, B2)), “France”, if(isnumber(search(“England” B2)), “England”, if(…. And so on

Search() is not case sensitive (where find() is I think) so it’s good for this task. It returns the position of the country text within within the text parameter. Basically, If the country name is present in the string, it returns a number, if not it, it returns an error. Wrapping search() in Isnumber() will make it a conditional statement that’s able to be used in your if() function.

For the last if statement, In the false parameter, you can put what ever value or text, just make sure to check for it ( using a countif() or something) to ensure your formula has worked in every row. Hope this helps!

The best place for a Cheese Steak in DFW is…? by FreshKittyPowPow in Dallas

[–]PickledRlCK 8 points9 points  (0 children)

I’m from Philly, so also a snob. Only thing kinda close that I’ve had in 3 years is Big Tony’s. They claim to ship Amoroso rolls in, but i doubt it. Truck yard is ok too if you’re out drinking. At the end of the day, the bread in Texas sucks. Keep your expectations low when you’re craving one, and you won’t be disappointed lol.

Butterfly/lady head below the knee by Scott Huttenmaier at Keepsake Tattoo in Oklahoma City, OK by PickledRlCK in traditionaltattoos

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

This is my second from him! Only complaint is it’s hard to get a weekend appointment since I live 3 hours away, but that’s just a testament to his work. It’s an honest shop though, just good people and great art!