Logo video2dn
  • Сохранить видео с ютуба
  • Категории
    • Музыка
    • Кино и Анимация
    • Автомобили
    • Животные
    • Спорт
    • Путешествия
    • Игры
    • Люди и Блоги
    • Юмор
    • Развлечения
    • Новости и Политика
    • Howto и Стиль
    • Diy своими руками
    • Образование
    • Наука и Технологии
    • Некоммерческие Организации
  • О сайте

Скачать или смотреть Excel -- Automatically Ranking Content (feat. ModelOff Finalist Martijn Reeker) - Episode 1615

  • MrExcel.com
  • 2012-12-11
  • 3474
Excel -- Automatically Ranking Content (feat. ModelOff Finalist Martijn Reeker) - Episode 1615
2010accountingBill JelenbusinessChampionshipCriteriaRankingDataExcelExcel 2010Excel TestingFunctionVLOOKUPValuesMartijn ReekersLearn ExcelMicrosoft ExcelModelOffMrExcelspreadsheetstechnologytutorialWorkbookWorkbooksMicrosoft Excel (Software)Software TutorialOfficeMicrosoft Office (Software)Data SetDueling ExcelMike GirvinExcel Duelbill and mike
  • ok logo

Скачать Excel -- Automatically Ranking Content (feat. ModelOff Finalist Martijn Reeker) - Episode 1615 бесплатно в качестве 4к (2к / 1080p)

У нас вы можете скачать бесплатно Excel -- Automatically Ranking Content (feat. ModelOff Finalist Martijn Reeker) - Episode 1615 или посмотреть видео с ютуба в максимальном доступном качестве.

Для скачивания выберите вариант из формы ниже:

  • Информация по загрузке:

Cкачать музыку Excel -- Automatically Ranking Content (feat. ModelOff Finalist Martijn Reeker) - Episode 1615 бесплатно в формате MP3:

Если иконки загрузки не отобразились, ПОЖАЛУЙСТА, НАЖМИТЕ ЗДЕСЬ или обновите страницу
Если у вас возникли трудности с загрузкой, пожалуйста, свяжитесь с нами по контактам, указанным в нижней части страницы.
Спасибо за использование сервиса video2dn.com

Описание к видео Excel -- Automatically Ranking Content (feat. ModelOff Finalist Martijn Reeker) - Episode 1615

Microsoft Excel Tutorial: Automatically Ranking Content in Excel: Cool Trick to Solve the Problem | MrExcel Podcast.

Welcome to another MrExcel podcast! I'm Bill Jelen and I'm here in New York City at the World Championship ModelOff Competition. I have the pleasure of being joined by Martijn once again as we tackle a common problem faced by Excel users - automatically ranking content. In this podcast, we will be discussing a cool trick that Martijn recently learned and how it can be applied to solve this issue.

Before we dive into the solution, let's set up the problem. We have a database with some ties in the Sales column, where multiple customers have the same revenue. Our goal is to sort this data using a formula. The sales portion is easy - we can use the =LARGE function to get the largest value. However, when we try to use VLOOKUP to retrieve the corresponding customer names, we run into a problem. The function will only return the first customer with the same revenue, leaving out the others. This is where Martijn's trick comes in.

Martijn will now explain the trick he learned to automatically rank contents. Imagine you have duplicate numbers in a column and you want to match them with something else, like a company name. Using the normal LARGE function will not differentiate between the duplicate numbers and will return the same company name for both. To solve this, Martijn suggests adding a small number (like a billion or million) to the duplicate numbers to make them unique. He demonstrates this using the ROW function and shows how it can be used in conjunction with the VLOOKUP function to get accurate results.

This is a hot trick and a great way to solve the problem of automatically ranking content. It's amazing how a small addition can make such a big difference in the functionality of a formula. I'm learning so much from the Excel rock stars here at the ModelOff Final in New York City. If you want to learn more tips and tricks like this, make sure to attend next year's ModelOff competition. And don't forget to tune in to our next netcast for more Excel insights from MrExcel. See you next time!

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-...


Table of Contents:
(00:00) Introduction to the problem
(00:11) Setting up the problem
(00:28) Using LARGE function to handle ties
(00:54) Issue with VLOOKUP and solution
(01:17) Explanation of the trick
(02:19) Adding a unique number to handle duplicates
(02:45) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial

This video answers these common search terms:
Duplicate numbers
Formula for sorting
LARGE function
Matching company names
ModelOff Final in New York City
ROW function
Sales column
Ties in sales
VLOOKUP
World Championship ModelOff Competition


Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads...

This video answers these common search terms:
Duplicate numbers
Formula for sorting
LARGE function
Matching company names
ModelOff Final in New York City
ROW function
Sales column
Ties in sales
VLOOKUP
World Championship ModelOff Competition


Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads...


Bill 'MrExcel' Jelen: [Almost] Live From New York City to judge the ModelOff Worldwide Excel Championship! With 16 Excel Rock Stars, from around the Globe, in NYC - and Bill having access to them all - why not do some Podcasting On-Site!
Our Dilemma: When we try to Sort with a Formula, the VLOOKUP will fail when there is a tie for the Sales Amount... But today, in Episode #1615, Martijn Reekers comes aboard The Learn Excel Podcast with a trick for getting all of the tied Values.

ModelOff is a worldwide competition to find the best Excel modellers with a $25,000 cash prize. For information on next year's competition, visit http://www.modeloff.com/modeloff-2013/

...This blog is the video podcast companion to the book, Learn Excel 2007 through Excel 2010 from MrExcel. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill's book! http://www.mrexcel.com/learn2010/LE20...

"The Learn Excel from MrExcel Podcast Series"

Visit us: MrExcel.com for all of your Microsoft Excel Needs!

Комментарии

Информация по комментариям в разработке

Похожие видео

  • О нас
  • Контакты
  • Отказ от ответственности - Disclaimer
  • Условия использования сайта - TOS
  • Политика конфиденциальности

video2dn Copyright © 2023 - 2025

Контакты для правообладателей [email protected]