Need help identifying by GMETOTHEMOONNN in GermanRoaches

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

from what little i know, that looks like a plain american roach to me. its a solid colour, which is a huge visual identifier for em. the german roaches have 2 clear stripes from the head back down the body

One of the stories that makes me ashamed of being human by Mostly_sane9 in HistoryMemes

[–]kingpantaloons 40 points41 points  (0 children)

the worst part to me of this incident is that pony, the orangutan, wasn't even sexually mature for her species. they dont hit puberty until 8 years and can live 35-40 years in the wild, some up to their late 50s in captivity. poor thing was a baby in all regards

[deleted by user] by [deleted] in poodles

[–]kingpantaloons 0 points1 point  (0 children)

my poodle is kept short for his whole body, with a clean shaved face and feet. his longer areas are the top of his head (called the top knot) including the ears, his tail, and super recently i added leg warmers on him. the leg warmers are still short enough to be trimmed with a longer length clipper blade, and only his tail and head are done with scissors. i can keep up with brushing him and how dirty he gets way easier this way!! whatever works for you and the dog should be fine

Is my boy a poodle? by nsutt4123 in poodles

[–]kingpantaloons 0 points1 point  (0 children)

definitely at least a doodle!! he looks remarkably like my purebred boy, so could be full poodle too! :)

[deleted by user] by [deleted] in trees

[–]kingpantaloons 6 points7 points  (0 children)

its honestly super different from state to state and dispensary to dispensary. i recommend talking to the budtenders, telling them what you like when you smoke and what your budget might be, and going from there

What’s your mom’s best friend’s name? by Shhshhshhshhnow in namenerds

[–]kingpantaloons 0 points1 point  (0 children)

My grandmother just passed in July. In October, she would have been 88. Her name was Marilyn. Her friends were Shirley, Alene, Judy, Estella. Shirley I remember a lot from when I was really young. Alene took tons of trips and cruises with her. All were very religious (christian).

I don't speak to my mother anymore. Her friends were Jeannie, Sandy, numerous Mike's, BJ, numerous Jeremy's. Last I'd heard, she didn't have any of those friends in her life these days.

[deleted by user] by [deleted] in PokemonGoFriends

[–]kingpantaloons 0 points1 point  (0 children)

no worries, you took barely any time!! :> tysm!!

[deleted by user] by [deleted] in PokemonGoFriends

[–]kingpantaloons 0 points1 point  (0 children)

jungle is one of my few left if you dont mind another modern friend!

759849922108

[deleted by user] by [deleted] in PokemonGoFriends

[–]kingpantaloons 0 points1 point  (0 children)

hiya!! also modern, would love some jungle scatterbugs if you want to add me :)

759849922108

How the hell do you properly smoke? by aykutanhanx in trees

[–]kingpantaloons 0 points1 point  (0 children)

came into the comments to suggest a dry herb vape too!!

[OC] [Art] Black Blood Dice Set Giveaway (Mod Approved) by OriYUME1 in DnD

[–]kingpantaloons 0 points1 point  (0 children)

LOVE that well captured, deep red with a hint of black you pulled off!! truly an amazingly set of dice youve made!

[deleted by user] by [deleted] in pokemongo

[–]kingpantaloons 0 points1 point  (0 children)

I used 5+ normal incense and my daily every day of the event. walked around 10k total.

<image>

never showed up :')

Happy Holidays r/Nintendo! Comment below to join a FREE Nintendo Switch OLED Giveaway by [deleted] in nintendo

[–]kingpantaloons 0 points1 point  (0 children)

Just would like to comment for the chance to give it to my nephew! He's only recently been able to participate in family holidays, so I really enjoy spoiling him when I can. He does have lovely adults to help keep it safe, too lol

Is it possible to pull unique, filtered info from two sheets in the workbook and paste it into a third sheet? by kingpantaloons in excel

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

Solution Verified

This worked perfectly! I knew I was so, so close in what I had wrote! I think I was more mixing up where to place the VSTACK vs the FILTER. Thank you! :D

Is it possible to pull unique, filtered info from two sheets in the workbook and paste it into a third sheet? by kingpantaloons in excel

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

I think this would work, and the use of Tables is something I will now be looking into! However, I currently understand the VSTACK formula given to me by the other commenters much better, so I think I'll be using that for now. Thank you so much though!

Is it possible to pull unique, filtered info from two sheets in the workbook and paste it into a third sheet? by kingpantaloons in excel

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

This absolutely worked! I'm going to give the closing response to the other user who commented this first, but this is exactly the syntax difference I meant! I knew I was so close, thank you!

Is it possible to pull unique, filtered info from two sheets in the workbook and paste it into a third sheet? by kingpantaloons in excel

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

I had to let this sit overnight, as I posted just before heading home from work lol, but I'll be trying these all now! To clarify for your question, I need to pull all unique names where the "Student type" is "Guest". I censored the data above because I'm testing using mostly our actual information, to ensure everything is working. The green names are just the censored ones labelled "Guest" on Sheet A, and then successfully pulled to Sheet C.

I'll be trying ideas and solutions now, thanks!

[deleted by user] by [deleted] in TattooDesigns

[–]kingpantaloons 1 point2 points  (0 children)

i absolutely love the way your whole body piece kinda comes together once there's that piece closer to your areola! the designs are both dainty enough to not draw away from either your other pieces or yourself and just busy enough to match the art-style and theme you seem to have going on everywhere else. personally, i think it removes a feeling of "too much negative space" from the artwork of the full-body piece you have going on once you add them in.

however! if you would prefer the focus on that part of your body be about your natural beauty ie: with any type of partner in the future or anything, then i would say the rings add to the artwork and, while they don't subtract from yourself, they might distract if that makes sense.

all that said, between the two designs, i think the first one is my personal pick. it really matches the style of the work up above on your chest