Video wird geladen...

Video konnte nicht geladen werden

Zur Startseite

Can VLOOKUP Return Multiple Columns? 🤔 By default, NO! 😢 But with a very small tweak...YES!!! Just put the column numbers in curly braces =VLOOKUP(G2,B2:E24,{3,4},FALSE) #exceltips #exceltricks #CheatSheet #programming #spreadsheets

143,199 Aufrufe • vor 3 Jahren •via X (Twitter)

0 Kommentare

Keine Kommentare verfügbar

Kommentare vom Original-Post werden hier angezeigt

Ähnliche Videos

Building a Backyard Arch. Follow up post to yesterday. This was a few years ago. No leads or strings. Just laying with a level. If I wanted it to be perfect, I could have set it up that way. But frankly, fun to freehand it. Feels more...artistic, and less scientific, this way. Note how easy the arch is! Put up formwork. Lay the brick over. Take formwork out. The arch is the shape masonry wants to be in; it keeps everything in compression. No steel or anything else necessary. This has literally been done for millennia. It's crazy how often the modern world (in the US) wants to complicate this. Make the interior concrete block, add steel and lintels, use metal ties to attach face brick....crazy!! Just build the dang thing out of solid brick. It's so simple. No need to complicate it. Lots of people asking about foundation. SUPER simple. Just a concrete footing. In Oklahoma that's just 24" deep. Did about 28" wide (with a 16" deep arch). Key is to do a continuous footing across, including below the opening, with rebar. Otherwise you can get differential settlement and it will crack. With this, even with movement, the footing moves as one piece, and the entire structure with it, so no cracking. Also, to answer another question, this is extremely heavy. Like 5,000+ pounds. Not going to blow over. Kids can climb all over it. A tornado could knock it down, but otherwise you are totally fine. Can you do this yourself? Yes. I'd start with laying a small wall to get used to the feel. But have had college students come down and build things like this over a week with zero prior experience. Main thing is it just takes them a very long time, and may look a little crude, but still beautiful.

Austin Tunnell

81,625 Aufrufe • vor 2 Jahren

Gilbert Strang, the legendary mathematician who taught linear algebra for 61 years and became the most watched math professor in history: "I used to think a matrix was just a grid of numbers, until I proved that its rows and columns always agree on one number no matter how you look at them. That fact still feels like magic to me after sixty years." this is the exact proof sitting quietly underneath every factor model a risk desk trusts with real capital, and almost nobody outside a math department has ever seen it. strip away the notation and the idea is almost absurdly simple. take any matrix, any grid of numbers, and count how many of its rows are truly independent, meaning none of them can be built out of the others. now count the independent columns instead, a completely different question on the surface. those two numbers, row independence and column independence, always turn out exactly equal, no matter how large or lopsided the matrix is. nobody presenting a clean risk model out loud credits a decades old proof for the reason the math even holds together. zoom out to what this means for anything built on a grid of numbers today. a portfolio, a covariance matrix, a neural network's weights, all of them hide a true dimension smaller than their size suggests, and that hidden number is exactly what this proof pins down. the industry sells complexity as scale, more assets, more parameters, more rows and columns. but the real question was never how big the matrix is. it's how many independent directions are actually hiding inside it. the size of the grid was never the real story. it was the one number both sides of it were quietly agreeing on the whole time.

MindArch

18,494 Aufrufe • vor 22 Tagen