Dynamic Array Functions in Excel: XLOOKUP, FILTER, UNIQUE, XMATCH

Dynamic Array Functions in Excel: XLOOKUP, FILTER, UNIQUE, XMATCH

Simon Sez IT

3 года назад

11,583 Просмотров

Ссылки и html тэги не поддерживаются


Комментарии:

mohamed adjal
mohamed adjal - 08.06.2023 20:52

good job

Ответить
Colin
Colin - 20.04.2023 05:44

Fortunately there is playback speed… so slow at normal speed… too much babble.

Ответить
David Gzirishvili
David Gzirishvili - 20.10.2022 19:26

Why to use array trick (with curly brackets) if the calculation can be done by SUMPRODUCT?

Ответить
Mina Fuchi
Mina Fuchi - 27.07.2022 05:34

Hi good morning
IAM from Nepal I watched all of your video it is a great job for students.iam a not students IAM a 35 years.i work in a larger company in warehouse really helpful yours video for me .
I request to you can you make about DXLOOKUP Function formula

Ответить
lmajiedmary
lmajiedmary - 25.02.2022 01:58

Great tutorial~~

Ответить
Bert Urselman
Bert Urselman - 07.10.2021 15:20

Hi Debby,

Thanks for this wonderfull course again.

I have a problem with the Control+Shift+Enter function. Any idea how to solve it?

Kind regards
Bert

Ответить
Graham Hilldrup
Graham Hilldrup - 04.12.2020 20:39

Once again, very informative. Thank you.

Ответить
darryl morgan
darryl morgan - 20.11.2020 17:56

Great Tutorial...Thank You Deb :)

Ответить
fayaz Ali
fayaz Ali - 17.11.2020 21:22

How can use filter formula in Excel 2019 version??

Ответить
Mohan Pal
Mohan Pal - 17.11.2020 20:53

Awesome trick sir

Ответить