正在加载视频...

视频加载失败

Difference Between SWITCH & IFS Function in MS #Excel =SWITCH(Measure,B6,C6,B7,C7,B8,C8,"Not Found!") =IFERROR(IFS(Measure=B6,C6,Measure=B7,C7,Measure=B8,C8),"Not Found!") =XLOOKUP(Measure,B6:B8,C6:C8,"Not Found!") =FILTER(C6:C8,B6:B8=Measure,"Not Found!")

76,207 次观看 • 3 年前 •via X (Twitter)

0 条评论

暂无评论

原始帖子的评论将显示在这里

相关视频

Steve Jobs: The difference between good people and great people is 50-to-1 “I’ve always considered part of my job was to keep the quality level of people in the organizations I work with very high. I mean that’s what I consider one of the few things I can contribute individually myself — versus the team that work with — is to really try to instill in the organization the goal of having only A players.” Steve argues this is especially important in technology where there’s a huge range between the best person and the worst person: “In a lot of fields, the difference between, say, the worst taxicab driver and the best taxicab driver to get you across town in Manhattan might be 2-to-1. The best one will get you there in 15 minutes, the worst one will get you there in half an hour… Or the best cook and the worst cook, maybe it’s 3-to-1… But in the field that I’m in. In software in particular. The difference between the best person and the worst person is about 100-to-1 or more.” He continues: “The difference between a good software person and a great software person is probably 50-to-1 or 25-to-1. Huge dynamic range. And therefore, I have found — and not just in software but in almost everything I’ve done — it really pays to go after the best people in the world.” But as Steve points out, this isn’t always easy: “It’s very painful when you have some people that are not the best people in the world, and you have to get rid of them. But I’ve found that my job has sometimes been exactly that, to get rid of some of the people that didn’t measure up. And I’ve always tried to do it in a humane way, but nonetheless it has to be done and it’s not ever fun.”

Startup Archive

45,143 次观看 • 5 个月前

Yesterday, I was overwhelmed by the support I received for my speech in Parliament. Many of you shared it widely, I had not posted it myself. I am now sharing the full speech again so those who missed it can watch how this government is excluding and targeting some of the most marginalised sections of our society. The fight will continue. We will not allow the rights of the LGBTQIA+ community and transgender persons to be diluted, and we will ensure that their dignity, identity, and constitutional protections remain intact. This Bill is a double assault on the transgender community’s dignity and rights: • While every MP in Parliament self declares their gender without scrutiny, transgender citizens are being forced to prove their identity before a medical board and the District Magistrate • From childhood, we are boxed into blue for boys and pink for girls, but identity is deeply personal and constitutionally protected • At a time when the LGBTQIA+ community is still fighting for recognition of same sex marriage, this government is taking us backwards by removing even the right to self identification • No meaningful consultation with the transgender community or stakeholders, despite Supreme Court led processes • The Bill invades privacy, enables discrimination, and opens the door to criminalisation This is not reform, this is regression. Not protection, but policing of identity. As Mahatma Gandhi reminded us, “The true measure of any society can be found in how it treats its most vulnerable members.”

Renuka Chowdhury

56,171 次观看 • 3 个月前