Hi
In this video, excel advance and pro functions are explained with examples and which will be helpful for freelancing and online earning as well.
Filter () is newly launched function & will be available soon in MS Excel versions. It return the multiple values by fulfilling the condition. In this video, data from adjacent columns get by concatenating filter with the choose function. Chose function select the data in columns and passing them to filter function as array and return the multiple matched values from the Table.