Learn about the NEW Dynamic Array Functions in Excel (Filter, Sort, Unique etc.)

Показать описание

Introducing the most game changing feature of Excel since Pivot Tables - Dynamic Arrays. This powerful new feature allows us to write formulas in a cell that can return an entire range of values (as against a single value).

In this video, you will get a complete overview of the functions and understand their behaviour thru several examples.

The dynamic array functions are,
FILTER
UNIQUE
SORT
SORTBY
SEQUENCE
RANDARRAY

Watch next:

#ExcelDynamicArrayFunctions #NewExcelFunctions #DAFunctions #HowtoUseDynamicArrrays

Рекомендации по теме

Комментарии

Thanks for the video on Dynamic Arrays. It was short and to the point. Thanks.

daleanderson

HI CHANDU ANNA NAMASTE.
YOUR EXPLINETION IS VERY GOOD AND WHAT EVER MAY BE YOUR EXPERIENCE IS HIEGH IS UNDERSTAND IN YOUR WAY OF TEACHING.
THANKS TO YOU ANNA.

sivareddy

You are Awesome..!!, Thanks for the great explanation!

shashirajusiddaraju

Very nice! Thanks a lot for sharing this! These are really going to be game changers!

vijayarjunwadkar

Awesome explanation Chandoo. Another great work from you. Wondering, If you could share the spreadsheet with us.

tahahafiz

Thank you for the content. Question, I'd like to know if I want to FILTER() the data that duplicate and shows sum of the QTY. How do I add countif(area, condition (sum of itself row > 2)) into filter function?

smithlo

Sir please make a video on OFFSET function and its variation with other most usable functions

sintulaha

cannot we have a pivot table where we can see who are the employees report to IAN

RA-rhlb

Hi sir, i was using the Filter function till yesterday, but iam not able to find these functions today, only FILTERXML is showing.. can you please help me with this.

capaulosealias

Great. Thanks. One question. How to extract (FILTER) data between two given dates?

vivekk

without using filter option how could I get all the information like filter function. It will be great helpful to me.

bibekkoirala

I have been using these new functions in my Office 365 subscription over the last few months and they are amazing. However I recently received an update and now they are all unrecognized by Excel and preceded by "_xlfn" in all my formulas.

julialewis

Audio is very feeble and not clear, please try hearing from youtube, you will understand

thangaveluraj

*Waste of time as you can do most of these functions in any table, and quicker*

tommyharris

Learn about the *NEW* Dynamic Array Functions in Excel (Filter, Sort, Unique etc.)