Sum variable and custom ranges with XLOOKUP: the Victor Momoh Edition
Автор: Excel On Fire (Oz du Soleil)
Загружено: 2022-03-01
Просмотров: 4466
I was on a couple of Meetup Zoom calls and Victor Momoh was the guest. He showed some fascinating stuff by using XLOOKUP to retrieve a range of data. He then used it to make sums and all kinds of other cool things. I share some of that in this video with you.
0:00 Introduction
0:24 My trip to Lagos
3:35 Using XLOOKUP to create the sum of a variable range
6:15 Using XLOOKUP to sum a variable range with variable start and end points
7:20 Using XLOOKUP and OFFSET to calculate variable distances
9:00 Outro
Victor Momoh presenting at the Saudi Arabia Excel Meetup Group.
• The Versatile Lookup Functions with Victor...
See Victor Momoh explain XLOOKUP returning a range instead of a value
• Getting Hyper with Hyperlinks | Victor Momoh
Victor's YouTube channel:
/ excelmoments
Download the workbook in this video:
https://datascopic.net/momoh
#XLOOKUP #SumRange #CalculateDistance
For a list of my Excel courses at Lynda/LinkedIn:
/ oz-du-soleil
There are courses on Power Query, Good spreadsheet habits, and a weekly Excel challenge that comes out every Friday.
Website: http://ozdusoleil.com
My book: Guerrilla Data Analysis 2nd Edition
http://www.amazon.com/Guerrilla-Analy...
My old blog: http://datascopic.net/blog-2-2
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке:
