Loading video...

Video Failed to Load

There was a problem loading this video. This could be due to a temporary network issue or the video might be unavailable.

Lookup & Return Multiple Values in Single Cell in #Excel (NO VBA | Easy Dynamic Array Formula) When the Lookup Values are Duplicates and Needs to Fetch Multiple Outputs | TEXTJOIN in Excel 2019 / 365 =TEXTJOIN(", ",TRUE,IF(A22=Data[Employees],Data[Skills],""))

Excel Basement

33,867 subscribers

87,769 views • 3 years ago •via X (Twitter)

Science & Technology Education #Excel

Anya Rossi• Live Now

Private livecam show

2 Comments

SaiKiran Kittu3 years ago

Can we use this formula...? =TEXTJOIN(", ",TRUE,FILTER(Data[Skills],Data[Employees]=A22,""))

Ratan Kumar Shukla3 years ago

@SaveMyVideo

Related Videos

Count / Sum Multiple Values in a Cell (Excel 365 Version) =COUNT(--TEXTSPLIT(MID(B5,2,LEN(B5)-2),{",","&"})) =SUM(--TEXTSPLIT(MID(B10,2,LEN(B10)-2),{",","&"})) =COUNTA(--TEXTSPLIT(MID(B14,2,LEN(B14)-2),{",","&"}))

Count / Sum Multiple Values in a Cell (Excel 365 Version) =COUNT(--TEXTSPLIT(MID(B5,2,LEN(B5)-2),{",","&"})) =SUM(--TEXTSPLIT(MID(B10,2,LEN(B10)-2),{",","&"})) =COUNTA(--TEXTSPLIT(MID(B14,2,LEN(B14)-2),{",","&"}))

Excel Basement

23,102 views • 2 years ago

Use of TAKE, SORT & FILTER Function in Microsoft #Excel using Dynamic Array Formula (HR Example) | How to get TOP n | BOTTOM n | TOP 3 (Criteria) TOP 5: =TAKE(SORT(Data,3,-1),5) BOTTOM 5: =TAKE(SORT(Data,3,1),5)

Use of TAKE, SORT & FILTER Function in Microsoft #Excel using Dynamic Array Formula (HR Example) | How to get TOP n | BOTTOM n | TOP 3 (Criteria) TOP 5: =TAKE(SORT(Data,3,-1),5) BOTTOM 5: =TAKE(SORT(Data,3,1),5)

Excel Basement

228,343 views • 3 years ago

Microsoft has just announced Copilot's ability to process data in Excel by generating Python code. - Request a detailed analysis - Copilot generates Python - Excel executes the code to show the result All without having to write a single formula. Just natural language. Huge deal for data analysis and visualization.

Microsoft has just announced Copilot's ability to process data in Excel by generating Python code. - Request a detailed analysis - Copilot generates Python - Excel executes the code to show the result All without having to write a single formula. Just natural language. Huge deal for data analysis and visualization.

Paul Couvert

373,713 views • 1 year ago

🚀 Stop Merging Data Manually in Excel! 📊 😫 Still copying and pasting data from multiple tables? There’s a smarter way. ⚡ Excel’s Consolidate feature lets you combine data from multiple ranges into a single summary in just a few clicks—saving time and reducing errors. ✅ Merge data faster ✅ Eliminate repetitive manual work ✅ Improve accuracy and productivity ✅ Perfect for reports, budgeting, and data analysis 💡 Small Excel tricks like this can save you hours over the course of a year. 📌 Save this post so you don’t forget it when working with spreadsheets! ❤️ Like • 🔄 Repost • 💬 Share with someone who still copies and pastes data manually.

🚀 Stop Merging Data Manually in Excel! 📊 😫 Still copying and pasting data from multiple tables? There’s a smarter way. ⚡ Excel’s Consolidate feature lets you combine data from multiple ranges into a single summary in just a few clicks—saving time and reducing errors. ✅ Merge data faster ✅ Eliminate repetitive manual work ✅ Improve accuracy and productivity ✅ Perfect for reports, budgeting, and data analysis 💡 Small Excel tricks like this can save you hours over the course of a year. 📌 Save this post so you don’t forget it when working with spreadsheets! ❤️ Like • 🔄 Repost • 💬 Share with someone who still copies and pastes data manually.

Tips Excel

557,801 views • 1 month ago

This is the noise coming from the Hyperscale Data Center in Dowagiac, Michigan Residents who live near by say they can no longer open the windows in their homes because of the noise and are very worried about their property values The Data Center is planning to expand

This is the noise coming from the Hyperscale Data Center in Dowagiac, Michigan Residents who live near by say they can no longer open the windows in their homes because of the noise and are very worried about their property values The Data Center is planning to expand

Wall Street Apes

401,466 views • 3 months ago

Are Data Centers Worth the Noise to Local Communities? "Multiple cities of people have filed lawsuits and complaints against these data centers because of the noise." "The first question I ask myself is, are we gonna need data centers in America? Yes, if we wanna compete in the modern world, in the modern economy, we are going to need them. They are good for society and good for the economy."

Are Data Centers Worth the Noise to Local Communities? "Multiple cities of people have filed lawsuits and complaints against these data centers because of the noise." "The first question I ask myself is, are we gonna need data centers in America? Yes, if we wanna compete in the modern world, in the modern economy, we are going to need them. They are good for society and good for the economy."

PBD Podcast

32,573 views • 2 months ago

Enrollment is now open for the Data Engineering Professional Certificate! Data engineers are the architects of modern organizations, ensuring data is reliable, accessible, and ready for analytics and machine learning. This professional certificate is tailored to equip you with the critical skills, through frameworks and hands-on practice, to excel in this role. Taught by industry expert Joe Reis, co-author of the best-selling book "Fundamentals of Data Engineering," along with 17 guest instructors from the data field, you will gain expertise to start and further your career in the high-demand field of data engineering. Key focus areas: 🗂️ Data Engineering Lifecycle: Learn the important stages of building an efficient data pipeline that creates business value. 📥 Data Ingestion: Learn how to efficiently gather data from various sources. 💾 Data Storage: Master the techniques for storing data securely and cost-effectively. 🔄 Data Transformation: Understand how to clean, organize, and prepare data for analysis and machine learning. 🏗️ Data Architecture Design: Build robust architectures that support scalable, efficient data workflows. 📊 Serving Data: Ensure that data is available to stakeholders when and where they need it to drive business decisions. Enroll now!

Enrollment is now open for the Data Engineering Professional Certificate! Data engineers are the architects of modern organizations, ensuring data is reliable, accessible, and ready for analytics and machine learning. This professional certificate is tailored to equip you with the critical skills, through frameworks and hands-on practice, to excel in this role. Taught by industry expert Joe Reis, co-author of the best-selling book "Fundamentals of Data Engineering," along with 17 guest instructors from the data field, you will gain expertise to start and further your career in the high-demand field of data engineering. Key focus areas: 🗂️ Data Engineering Lifecycle: Learn the important stages of building an efficient data pipeline that creates business value. 📥 Data Ingestion: Learn how to efficiently gather data from various sources. 💾 Data Storage: Master the techniques for storing data securely and cost-effectively. 🔄 Data Transformation: Understand how to clean, organize, and prepare data for analysis and machine learning. 🏗️ Data Architecture Design: Build robust architectures that support scalable, efficient data workflows. 📊 Serving Data: Ensure that data is available to stakeholders when and where they need it to drive business decisions. Enroll now!

DeepLearning.AI

20,833 views • 1 year ago

I used Claude Code Skills + souped up PDF parsing to create an M&A deal comp agent 🤖 Given a directory of public M&A filings (DEF 14A), it parses and analyzes each pdf, and generates an Excel sheet with deal terms and comparables. 1️⃣ The native parsing is pypdf which sucks, so I swapped it out with LlamaIndex semtools. This uses LlamaCloud for parsing - letting it handle deeply complex financial tables, charts, and anything else you throw at it. 2️⃣ Claude has native skills to write Excel spreadsheets! Full prompt is in the video below 👇 LlamaCloud + Semtools access also takes < 5 mins to setup, come check it out! Some notes: - disclaimer: Some of the values in the Excel spreadsheet are 100x bigger because they’re formatted as percentages not raw values - We’re working on native Claude skill integrations too! Semtools: LlamaCloud:

I used Claude Code Skills + souped up PDF parsing to create an M&A deal comp agent 🤖 Given a directory of public M&A filings (DEF 14A), it parses and analyzes each pdf, and generates an Excel sheet with deal terms and comparables. 1️⃣ The native parsing is pypdf which sucks, so I swapped it out with LlamaIndex semtools. This uses LlamaCloud for parsing - letting it handle deeply complex financial tables, charts, and anything else you throw at it. 2️⃣ Claude has native skills to write Excel spreadsheets! Full prompt is in the video below 👇 LlamaCloud + Semtools access also takes < 5 mins to setup, come check it out! Some notes: - disclaimer: Some of the values in the Excel spreadsheet are 100x bigger because they’re formatted as percentages not raw values - We’re working on native Claude skill integrations too! Semtools: LlamaCloud:

Jerry Liu

46,748 views • 8 months ago

🚨 HOLY SMOKES. 29 states are HIDING voter roll data from the Trump DOJ... ...which has ALREADY found 350,000 DECEASED people on the rolls in multiple jurisdictions AAG Harmeet Dhillon has referred 25,000 people with NO CITIZENSHIP records to DHS to see if and when they voted 🤯 What are they hiding? Keep pushing hard, AAGHarmeetDhillon!

🚨 HOLY SMOKES. 29 states are HIDING voter roll data from the Trump DOJ... ...which has ALREADY found 350,000 DECEASED people on the rolls in multiple jurisdictions AAG Harmeet Dhillon has referred 25,000 people with NO CITIZENSHIP records to DHS to see if and when they voted 🤯 What are they hiding? Keep pushing hard, AAGHarmeetDhillon!

Eric Daugherty

322,778 views • 2 months ago

🚨WIND DATA GLITCH COULD SCRUB AXIOM-4 FLIGHT As Dragon sits poised with its AX-4 crew strapped in for a 28-hour journey to the ISS, a data snag has hit the countdown clock. Mission control flagged a glitch in uploading current wind conditions to the vehicle, critical for targeting an offshore splashdown if the launch escape system kicks in. Crew was told flatly: if the data isn't uploaded in time, today's launch is no go. Teams are hustling through multiple troubleshooting paths. Source: SpaceX

🚨WIND DATA GLITCH COULD SCRUB AXIOM-4 FLIGHT As Dragon sits poised with its AX-4 crew strapped in for a 28-hour journey to the ISS, a data snag has hit the countdown clock. Mission control flagged a glitch in uploading current wind conditions to the vehicle, critical for targeting an offshore splashdown if the launch escape system kicks in. Crew was told flatly: if the data isn't uploaded in time, today's launch is no go. Teams are hustling through multiple troubleshooting paths. Source: SpaceX

Mario Nawfal

33,621 views • 1 year ago

If your financial model doesn’t tell you how sensitive your outcomes are to key assumptions, you’re only seeing half the picture. That’s where Sensitivity Analysis steps in. Whether you're modeling EBITDA, company valuation, or cash flow, testing the impact of changes in assumptions—like growth rate, margin, or discount rate—is crucial for informed decision-making. 📊 3 Powerful Tools in Excel for Sensitivity Analysis: 1️⃣ Data Tables Easily test the impact of one or two input variables on a key output. Perfect for: Valuation scenarios, breakeven analysis, IRR stress tests. 2️⃣ Scenario Manager Create and store multiple input sets and compare outputs. Perfect for: Best case / base case / worst case planning. 3️⃣ Manual What-Ifs with Named Ranges + Excel Formulas Use dynamic formulas, dropdowns, and structured inputs to test anything. Perfect for: Custom, presentation-ready models with clear audit trails. 💡 Pro Tip: Combine sensitivity analysis with clear data visualization (charts, conditional formatting, slicers) to drive your story home. Finance isn't just about building the model—it's about telling the right story with the right levers. 👇 How do you use sensitivity analysis in your day-to-day modeling? HERE IS A VIDEO

If your financial model doesn’t tell you how sensitive your outcomes are to key assumptions, you’re only seeing half the picture. That’s where Sensitivity Analysis steps in. Whether you're modeling EBITDA, company valuation, or cash flow, testing the impact of changes in assumptions—like growth rate, margin, or discount rate—is crucial for informed decision-making. 📊 3 Powerful Tools in Excel for Sensitivity Analysis: 1️⃣ Data Tables Easily test the impact of one or two input variables on a key output. Perfect for: Valuation scenarios, breakeven analysis, IRR stress tests. 2️⃣ Scenario Manager Create and store multiple input sets and compare outputs. Perfect for: Best case / base case / worst case planning. 3️⃣ Manual What-Ifs with Named Ranges + Excel Formulas Use dynamic formulas, dropdowns, and structured inputs to test anything. Perfect for: Custom, presentation-ready models with clear audit trails. 💡 Pro Tip: Combine sensitivity analysis with clear data visualization (charts, conditional formatting, slicers) to drive your story home. Finance isn't just about building the model—it's about telling the right story with the right levers. 👇 How do you use sensitivity analysis in your day-to-day modeling? HERE IS A VIDEO

Bojan Radojicic

14,714 views • 5 months ago

Sen. Patty Murray: "I'm just sickened by this. To go into this war unprepared, to use outdated data, and to have this horrific thing happen where children were killed in a school sends a horrible message to those that are in a war with us and to our own constituents about what America's values are. This is unacceptable. The administration needs to be held accountable."

Sen. Patty Murray: "I'm just sickened by this. To go into this war unprepared, to use outdated data, and to have this horrific thing happen where children were killed in a school sends a horrible message to those that are in a war with us and to our own constituents about what America's values are. This is unacceptable. The administration needs to be held accountable."

Aaron Rupar

64,769 views • 4 months ago

SACKS: “We're really lucky that [Trump] is President … when this AI revolution is happening.” JASON: “What would happen if Kamala ‘Ding Dong’ was in right now?” SACKS: “We'd have no data centers, they'd be using AI to censor us, and they'd be promoting DEI values through AI.”

SACKS: “We're really lucky that [Trump] is President … when this AI revolution is happening.” JASON: “What would happen if Kamala ‘Ding Dong’ was in right now?” SACKS: “We'd have no data centers, they'd be using AI to censor us, and they'd be promoting DEI values through AI.”

Chief Nerd

876,653 views • 2 months ago

SACKS: “WE'RE REALLY LUCKY THAT [TRUMP] IS PRESIDENT … WHEN THIS AI REVOLUTION IS HAPPENING.” JASON: “WHAT WOULD HAPPEN IF KAMALA ‘DING DONG’ WAS IN RIGHT NOW?” SACKS: “WE'D HAVE NO DATA CENTERS, THEY'D BE USING AI TO CENSOR US, AND THEY'D BE PROMOTING DEI VALUES THROUGH AI.”

SACKS: “WE'RE REALLY LUCKY THAT [TRUMP] IS PRESIDENT … WHEN THIS AI REVOLUTION IS HAPPENING.” JASON: “WHAT WOULD HAPPEN IF KAMALA ‘DING DONG’ WAS IN RIGHT NOW?” SACKS: “WE'D HAVE NO DATA CENTERS, THEY'D BE USING AI TO CENSOR US, AND THEY'D BE PROMOTING DEI VALUES THROUGH AI.”

Vivek Sen

291,118 views • 1 month ago

We just launched a major new Data Engineering Professional Certificate on Coursera! Data underlies all modern AI systems, and engineers who know how to build systems to store and serve it are in high demand. If you're interested in learning this skill, please check out this 4-course sequence, which is designed to make you job-ready to be a Data Engineer. This is a new specialization taught by Joe Reis, the co-author of the best-selling book “Fundamentals of Data Engineering," in collaboration with AWS. (Disclosure, I serve on Amazon's board.) For many AI systems, data engineering is 80% of the work, and modeling is 20%. But people’s attention on these two topics is often flipped. This makes the job of the data engineer particularly important. In this professional certificate, you'll learn foundational data engineering skills while implementing modern data architectures using open-source tools: - Learn the key steps of the data lifecycle, to generate, ingest, store, transform, and serve data. - Learn to align with organizational goals to design the data pipeline right for your business' needs. - Understand how to make necessary trade-offs between speed, scalability, security, and cost. Joe has distilled into this specialization decades of experience helping startups and large companies with data infrastructure. He is also joined by 17 other industry leaders in the data field, who will help you learn in-demand skills for the growing field of data engineering. Please sign up here:

We just launched a major new Data Engineering Professional Certificate on Coursera! Data underlies all modern AI systems, and engineers who know how to build systems to store and serve it are in high demand. If you're interested in learning this skill, please check out this 4-course sequence, which is designed to make you job-ready to be a Data Engineer. This is a new specialization taught by Joe Reis, the co-author of the best-selling book “Fundamentals of Data Engineering," in collaboration with AWS. (Disclosure, I serve on Amazon's board.) For many AI systems, data engineering is 80% of the work, and modeling is 20%. But people’s attention on these two topics is often flipped. This makes the job of the data engineer particularly important. In this professional certificate, you'll learn foundational data engineering skills while implementing modern data architectures using open-source tools: - Learn the key steps of the data lifecycle, to generate, ingest, store, transform, and serve data. - Learn to align with organizational goals to design the data pipeline right for your business' needs. - Understand how to make necessary trade-offs between speed, scalability, security, and cost. Joe has distilled into this specialization decades of experience helping startups and large companies with data infrastructure. He is also joined by 17 other industry leaders in the data field, who will help you learn in-demand skills for the growing field of data engineering. Please sign up here:

Andrew Ng

118,937 views • 1 year ago

Revamped Freya Updated Skills Gameplay The updated and revamped Freya now deals damage to enemies with her ultimate teleportation skill. Also, if you defeated multiple enemies while in ultimate mode, your Valkyrie mode becomes permanent. You will only return to normal mode if you are killed. Repost shen fb

Revamped Freya Updated Skills Gameplay The updated and revamped Freya now deals damage to enemies with her ultimate teleportation skill. Also, if you defeated multiple enemies while in ultimate mode, your Valkyrie mode becomes permanent. You will only return to normal mode if you are killed. Repost shen fb

Txtmlbb2

33,016 views • 1 year ago

David Sacks: We're lucky that Trump's the President when this AI revolution is happening. @jason "Do an alt history, Sacks, what would happen if Kamala Ding Dong was in right now?" David Sacks "We'd have no data centers, and they'd be using AI to censor us, and they'd be promoting DEI values through AI. That was in the Biden executive order. President Trump just wants the country to win and be successful.

David Sacks: We're lucky that Trump's the President when this AI revolution is happening. @jason "Do an alt history, Sacks, what would happen if Kamala Ding Dong was in right now?" David Sacks "We'd have no data centers, and they'd be using AI to censor us, and they'd be promoting DEI values through AI. That was in the Biden executive order. President Trump just wants the country to win and be successful.

jay plemons

96,689 views • 2 months ago

In Kafka, we have topics. Producers send data to a topic, and consumers pull data from it. Each topic has multiple partitions. You might have heard your team lead say that we can simply increase the partition count to make our cluster more scalable. There is no ordering guarantee across partitions for a topic, but messages within a partition are ordered. This can be confusing initially, but think of consumer groups as subscribers: each group has multiple consumers pulling data from a topic, and the group maintains its own offset for that topic. Check out the pinned post on my profile to understand this in detail!

Abhishek Singh

16,942 views • 5 months ago

In my experience, robot 'generalists' are often jacks of all trades but masters of none. In training across multiple tasks and environments, robot policies fail to generalize robustly and effectively to each particular test setting. What if at test time, we non-parametrically *retrieved* “relevant” data from the training set and used it to significantly improve the performance of few-shot imitation learning to be robust to various test time scenes. Notably, we are *not* collecting lots of new data, just training more on sub-components of the same training data! Now, we’re certainly not the first to suggest retrieval, but in our new work - STRAP, we show how retrieving relevant *sub-trajectories* from offline datasets can significantly increase data reuse across tasks, when paired with an appropriate metric space. A 🧵 (1/7)

In my experience, robot 'generalists' are often jacks of all trades but masters of none. In training across multiple tasks and environments, robot policies fail to generalize robustly and effectively to each particular test setting. What if at test time, we non-parametrically retrieved “relevant” data from the training set and used it to significantly improve the performance of few-shot imitation learning to be robust to various test time scenes. Notably, we are not collecting lots of new data, just training more on sub-components of the same training data! Now, we’re certainly not the first to suggest retrieval, but in our new work - STRAP, we show how retrieving relevant sub-trajectories from offline datasets can significantly increase data reuse across tasks, when paired with an appropriate metric space. A 🧵 (1/7)

Abhishek Gupta

12,045 views • 1 year ago

LLM hallucinations are the biggest roadblock for enterprises adopting AI. You can’t build real systems on outputs you can’t trust. Fetch Business changes that. When you claim your brand agent, it has access to real data, represents your brand accurately 24/7 and boosts consumer service. Better consumer relationships = better sales. Claim your agent in less than 60 seconds: 👇

Fetch.ai

14,894 views • 1 month ago