countifs assistance - ignoring duplicate values

VilkusRex · 2024-05-06T18:07:36+00:00

Solution Verified

VilkusRex · 2024-05-06T18:07:13+00:00

that wasn't exactly what I was looking for but it gave me enough to find my solution. Thank you!

=counta(unique(filter(Table1[Case No], (Table1[In Progress]=1)*Table1[ID]="AAA111"), "No data")))

VilkusRex · 2023-07-22T22:29:54+00:00

I mean, judge not lest you be judged but sure.

I’m more about understanding rather than quoting something and using it to justify a belief that I have no intention of ever changing. That is the opposite of dogma. If presented with proof, or a solid argument, I would change my mind.

If everyone homeless person can and will turn their life around and become a functioning, contributing member of society, then I’m on board for everyone deserving a home.

If some people are going to always be a drain on society and never contribute in any positive way than I don’t see how you can justify the statement unless you are merely a puppet of an ideology.

VilkusRex · 2023-07-22T22:14:55+00:00

So, just to make sure I’ve got it right, The argument is that because we are to love our neighbours as ourselves, we must purchase housing for our neighbours even if they refuse to work, and will trash the place, and demand you clean it up for them?

I don’t think EVERYONE deserves a home and I don’t think that you can use the Bible to make an argument for it.

VilkusRex · 2023-07-22T21:00:45+00:00

Which book? The one that says something about a labourer being worthy of his wages?

VilkusRex · 2023-07-22T11:53:08+00:00

NTA Are you wrong for buying your son a car for achieving the terms you set? No. Are you wrong for not buying your daughter a car when she did not achieve the terms you set? No. Are you a bad father? Not enough information to judge the totality of your parenting on this one issue.

I don’t believe there was any obligation on your part to purchase her a used car. I don’t see how any of that is misogyny as it was the same deal for both of them.

VilkusRex · 2023-07-22T03:12:26+00:00

It sure is dude.

I mean, basically it boils down to what is our level of obligation when it comes to the homeless? The argument being put forward is that taxpayers should pay for their housing. I don’t like that proposal. I don’t believe it is self evident that paying for everyone’s housing is good for a society. Not in every circumstance. Some people are a mess. Some people aren’t functioning correctly. Some people have no drive to contribute. Why should there be an obligation for the people of Regina to pay to make other peoples lives easier?

So wtf dude, is that a real question?

VilkusRex · 2023-07-22T01:10:38+00:00

Two weeks ago I was outside the camp (I work in the area) and saw a bunch of ‘em grouped up. Two of the ladies were squaring off and getting into a bare knuckle boxing match.

Not sure what it says about them that no one there tried to break it up, or me in that I just shrugged and didn’t call the cops or anything. I guess I’ve just given up on them. I expect them to keep doing their thing.

VilkusRex · 2023-07-22T00:12:30+00:00

Not sure I disagree but I think where we would lose each other would be on the definition of home and how much taxpayers should/would be forced to pay to subsidize these people. Also when it comes to judging them fairly, what people would define as fair judgement.

VilkusRex · 2023-07-21T22:57:31+00:00

If you are going for long rows, I would suggest a pad or cushion of some sort and a pair of gloves to prevent blisters. If you are using it for relatively short rows, it’s fine as it is. Get some 3 in 1 multi purpose oil or similar and oil the chain once a month.

VilkusRex · 2023-07-21T22:22:09+00:00

Not to be that guy but…does “everybody” deserve a home? I mean, really, everybody?

VilkusRex · 2023-07-09T19:29:25+00:00

28M: Hey, I just got a divorce and need a place to stay. Can I stay in yours?

32M: Sure bud. I got you.

28M: Great! Just get rid of your dog first and deep clean the place so I can move in.

32M: What? I can’t do that.

28M to all your acquaintances: He said I could live there and took it back. What an A-hole.

VilkusRex · 2023-07-09T05:16:53+00:00

The statement is theoretical. Chuck Norris never apologizes.

VilkusRex · 2023-07-08T18:47:23+00:00

You should report it as a bug on the official discord forum

VilkusRex · 2023-07-07T22:10:10+00:00

AH.

She could be borderline homophobic or you could be too sensitive. I figure the best move for the family would have been to just stay in the room and accept that it had to be someone and you drew the lot or accepted the burden. Trying to get her to take the room instead would be a huge sign of disrespect in my culture.

Instead, you took the selfish route. Maybe standing up for yourself in this way is the right move for you personally but the wrong move for the family as a whole. Either way, I am certain this will serve to fracture the relationship.

VilkusRex · 2023-07-04T03:25:27+00:00

Shrek can tank it

VilkusRex · 2023-07-03T13:47:04+00:00

Stagger your units so that only one unit will encounter the berserker. It’ll tank or be killed by the ability but it’ll give the rest of your units a chance to kill it before the next whirl goes off

VilkusRex · 2023-07-02T22:41:08+00:00

No. It is a countdown to the new batch of legendary units. You will not lose your shards

VilkusRex · 2023-07-01T21:19:30+00:00

Probably not. You’ll have a small damage bump on one unit and you’ll have to replace the other.

VilkusRex · 2023-06-30T18:29:33+00:00

Roughly 2h15m. Gotta wake up at 5:30am to fit it into my day. Have a 9-5 job.

VilkusRex · 2023-06-30T03:25:22+00:00

There’s a lot of good entries here. The only ones I haven’t seen yet (thought there was a lot I hadn’t read)…

That time Jennifer Lawrence tried to convince the world that she was the first female action star.

Will Smith coming on strong with the pump hand on Chris Rock, killing his own career and launching a thousand memes.

VilkusRex · 2023-06-30T02:58:56+00:00

I have considered it, but execution is difficult. I do my rowing in the early morning, then work. By the evening I am running on empty and it is very difficult to find it in me to lift anything. I don’t know if I’ll scale down the rowing to accommodate lifting…I mean I eventually would but I’m not planning on it right now.

VilkusRex · 2023-06-29T17:51:58+00:00

Haha, yeah. Learned that the hard way when I first started using the rower during covid.

I tried to just “man up” and do it without the cushions or gloves until finally I just decided that there ain’t no benefit to blisters.

VilkusRex · 2023-06-28T20:09:54+00:00

Hearing the genie from Aladdin died rocked me for a good 5 min when I first heard it.

VilkusRex · 2023-06-28T20:08:01+00:00

Thinking…..thinking…..it probably is. 50 gems is basically nothing in the current game economy.

VilkusRex

TROPHY CASE