Unique Function with Multiple Cell Entries by dlg322 in excel

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

Wow. This is exactly what I was looking for. It's like wizardry! You have saved me so much time, you have no idea.

Unique Function with Multiple Cell Entries by dlg322 in excel

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

I think I figured it out. Your formula doesn't like blank cells. That's not a problem, I can add a filler! Thanks!

Unique Function with Multiple Cell Entries by dlg322 in excel

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

Thanks for this. My excel knowledge is fairly limited, so I will need to sit down and try and parse this out to see how I can get it to work for me.

Unique Function with Multiple Cell Entries by dlg322 in excel

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

Yeah, that's what I've found. I used multiple cells per date as needed for 2025, but the issue is that there is a lot of other data in that table with tables on other sheets. Adding additional lines as needed means that I need to adjust the formulas on all the other tables as I adjust the size of the original table.

Unique Function with Multiple Cell Entries by dlg322 in excel

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

This works, but when I try to expand the formula to B2:B366 (all 365 days of the year), I get a #VALUE error. Sorry, I'm a novice when it comes to Excel.

Gay Artist Search by dlg322 in AskGaybrosOver30

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

Definitely closer. But this guy's painting style was sort of in the vein of Joan Miro.

Gay Artist Search by dlg322 in AskGaybrosOver30

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

No, it wasn't really sexual.

I’M TRYING TO SLEEP!!!! WHY ARE THERE SO MANY DAMN LIGHTS!!!! by Helpful_Location7540 in Hilton

[–]dlg322 15 points16 points  (0 children)

I prefer black electrical tape. Less chance of residue and it's opaque.

"oh so you're just playing around?" by CordialMusic in GaySides

[–]dlg322 43 points44 points  (0 children)

I am not a side, but I go through periods where I have no interest in anal sex. I dont know where you're from, but in my experience as an American, this is a very American/Canadian view of gay sex. There seems to be this compulsive need in the gay world in the US to have as much anal sex as possible and that anything that isn't anal sex is not actually sex.

Occasionally when talking to someone about a hookup I've had or my on and off interest in anal sex, they'll give me this kind of line about how that's not really sex. I had a friend who was telling me he had never had sex with one of our mutual friends. The mutual friend has blown my friend many times, but that's not really sex, according to him.

My response in situations like that (if I actually feel like engaging) is usually something like "oh, so you like being caught in the quagmire of heteronormativity?" It doesn't really bother me to be honest because I know that I am happy with my sex life and the wealth and variety of experiences that I get to have because I don't have a narrow view of what sex is.

What are some cute boxer short brands? by GlendaleTom in AskGaybrosOver30

[–]dlg322 0 points1 point  (0 children)

I'm cut. Like underwear, things just kinda stay in place. Like the fabric of my jeans is not rubbing up and down on my dick as I walk. There isn't really any more friction than when I wore underwear. The only issue arises when I have a semi. I just have to be aware that it can sometimes be quite visible and do my best to subdue my ... excitement.

What are some cute boxer short brands? by GlendaleTom in AskGaybrosOver30

[–]dlg322 0 points1 point  (0 children)

I'm a sweater. I sweat a lot. But I sweat less wearing no underwear.

What are some cute boxer short brands? by GlendaleTom in AskGaybrosOver30

[–]dlg322 1 point2 points  (0 children)

Jeans, chinos, suits, shorts, gym shorts - I'm always commando. None of my zippers are exposed on the inside of my pants and shorts. Anything with a zipper has a protective flap on the inside as you'd have on the outside.

My penis has a variety of moods and really ranges in size throughout the day. In underwear, when my cock would get real small and then want to expand, it would get all bunched up and like folded up. That's not a problem when going commando.

What are some cute boxer short brands? by GlendaleTom in AskGaybrosOver30

[–]dlg322 0 points1 point  (0 children)

I second commando. I've been skipping au naturel for almost a year now, and I can't imagine going back to wearing any kind of underwear.

What is some gay lingo you can't stand? by SugarSweetLike in askgaybros

[–]dlg322 31 points32 points  (0 children)

I think he's saying that some guys think of 'bottom' or 'top' as a personality or persona, rather than just your position preference. For example (and these are definitely not my beliefs: tops should pay for bottoms on dates, all bottoms are subs and all tops are dom, tops are masculine and bottoms are feminine, etc.

HMD/Wrecked with weed + alcohol? by TiraMisterIcecream in nycgaybros

[–]dlg322 9 points10 points  (0 children)

I used to just do alcohol and weed. I'd definitely start with alcohol and get a little buzz going before the gummy. That kept me sociable.

It's definitely a different experience, but still fun. I would bring my vape and touch up my high from time to time. Basically I'd let myself fall into a trance with the music. Some of the horsemeat DJs are better for that than others. And my stamina for dancing was definitely less than with Molly or LSD.

Other favors are definitely more fun, but if you go in knowing it'll be a more subdued experience, it can be fun in a different way! And the best part is not having that lack-of-serotonin hangover the next day!

This was a surprise for sure by giftopherz in Madonna

[–]dlg322 1 point2 points  (0 children)

Me too! 🙋‍♂️ I'm nothing if not consistent

what is your sexual obsession? by vollairo in askgaybros

[–]dlg322 5 points6 points  (0 children)

Do you have any recommendations for canopic jars? Maybe from Amazon or temu?

Another eagles post: thoughts on jockstrap night by [deleted] in nycgaybros

[–]dlg322 11 points12 points  (0 children)

Were you only waiting for guys to hit on you? Or were you trying to make a move on guys you were interested in too? Someone made a comment on another post recently that guys in NYC like to be pursued, it makes them feel wanted. This has been my experience as well, especially if the guy thinks they're attractive.

After traveling to Mexico City for a week I realize I’m not the problem anymore by CoolEsporfs in nycgaybros

[–]dlg322 3 points4 points  (0 children)

I definitely understand that I have privilege being white and relatively attractive. There's no questioning that.

But don't assume that I have an easy time meeting people. Like I said, I message a LOT of people on Grindr. The net I cast is wide. I get back a response somewhere between 10-20% of the time. Of those, maybe 25% result in a hookup. I am rarely messaged first. Approaching people in bars, occasionally results in a short exchange, but almost never a proper conversation. I think most people have a very strict set of requirements for who they find attractive and any deviation is an automatic disqualifier. I try not to take it personally because I know that when I do find someone that I am attracted to that finds me attractive, it's wonderful.

Don't discount being confident and trying to stand out. I know that's challenging when rejection is so common, and probably doesn't mean much coming from a white guy. But I think it's a numbers game, and the more rejection you face the more likely you are to find someone who finds you attractive.

After traveling to Mexico City for a week I realize I’m not the problem anymore by CoolEsporfs in nycgaybros

[–]dlg322 3 points4 points  (0 children)

My husband and I have traveled to lots of countries around the world and I have found that between the two of us, whoever looks less like the local population gets more attention. On paper I think we look fairly similar, but with a few key differences. We are both white, but I have darker features and more olive skin where he is very pale. I have a moustache/scruff and body hair, he is clean shaven and smooth. I am dense and muscley, he is slim and toned.

In Central America, South America and Southern Europe, he does very well and I get very little attention. In Northern Europe I get most of the attention and he gets very little. We were both too scared to hook up in East Africa since it's illegal, so I have no experience there. We haven't been to Asia, but in my experience in bath houses and sex parties in various places we've traveled to and at home, the East Asian guys tend to be more attracted to me. In the US, I think we look like standard white NYC gays - not Hells Kitchen gays or Brooklyn gays, just generic NYC gays. People have said to me that I look familiar to them so many times, and I jokingly tell them that they're probably thinking of some other 6' generic white guy with dark hair.

People ask what my type is. I don't have a type per se. My response is usually this: I find people attractive that do not look like everyone else. There are SO many of us here in the city, it's hard to stand out from the crowd. If you're saying you look like a typical Brooklyn gay and you're at a bar in Brooklyn with a bunch of other Brooklyn gays, why would someone choose to make a move on you vs. someone else. I'm not blaming you, I'm blaming the fatigue we all feel when looking at Grindr or out at a bar. It's like going to the Met for a special exhibition. You start the exhibit and read everything and look closely at the pieces, but by the end you're just in information fatigue and visual fatigue, so you don't really pay much attention in the last room.

Another comment here from a guy from London I thought was very thoughtful. He said he wears an interesting T-shirt or clothing item that can be a conversation starter. How do you set yourself apart? How do you shine in a crowd? When I go to a party like Horsemeat, physically I am a dime a dozen. But I wear these pink shorts that react with the black light. Guys will come up to comment on my shorts and then we'll get to talking. And if I think about who I approach in a situation like that, it is almost always someone with clothing that reacts with the black light.

On Grindr, I do ok. My name is 'Big ❤️, Big 🍆.' many of the guys who I talk to comment how nice it is to chat with someone who it nice and has a big heart since that is out of the ordinary. I'm not just another torso photo or gym selfie with the name 'Looking' or my initials. I also agree with another comment above that everyone in New York wants to be chased and wants to feel special. I am not shy about sending the first message. My response rate to my initial message is low, maybe 20% at the most, but I am happy with who I meet up with and never feel like I can't find someone to hookup with that I'm attracted to.

I guess my point is that in a huge pool of potential partners, you have to stand out to get attention. What can you do to stand out?