Use FILTER, SORT & SORTBY formula in MS Excel || Basic to Advance Microsoft Excel

Use FILTER, SORT & SORTBY formula in MS Excel || Learn Microsoft Excel Formulas in just one minute.

*****************************************************************
1) The Excel FILTER function filters a range of data based on supplied criteria, and extracts matching records. Filters range with given criteria. Array of filtered values. =FILTER (array, include, [if_empty]) array - Range or array to filter.

2) The Excel SORT function sorts the contents of a range or array in ascending or descending order. Values can be sorted by one or more columns. SORT returns a dynamic array of results.

3) The SORTBY function sorts the contents of a range or array based on the values in a corresponding range or array.

*****************************************************************
Watch our other videos on conditional formatting
***********************************************************************
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
***********************************************************************
***********************************************************************

Quickly learn Microsoft Excel advanced formulas || Learn Smartly

Learning should always be easy and fast. Codebusted videos are meant to make your learning experience smooth, easy to understand, short, and precise. Subscribe and embark on a journey of fast-track learning.

Post any technical queries, We are here to resolve your all technical query..

#excel
#Education
#sortby
#Filter

[bhartiyacomputers]

my filter result comes with heading also why?

[unknwn_usr]

Why I cant I use Normal Sorting on filtered data?

[kamleshchavan]

Instead of background music , you should have explained what you were doing