Learn MS Excel -Video 440- How to Sum unique values- Arrays

In this video we are using array formula which is summing up the unique values in a table and also[…]

Read More...

Learn MS Excel – Video 378- Arrays- Reverse the text -Mid transpose Conct offset

We are reversing the characters of a string using so many functions as stated in the title and making such[…]

Read More...

Learn MS Excel – Video 370- Powerful Arrays – Sum sales if name contains specific word

Check out the another terrific example of Arrays where we are learning how to combing IFERROR, FIND and IF function[…]

Read More...

Learn MS Excel – Video 375- Arrays – Case study – Indirect address Offset row

Another puzzle solved using fantastic array technique where we combined INDIRECT ADDRESS OFFSET ROW LARGE in one powerful formula -~-~~-~~~-~~-~-[…]

Read More...

Learn MS Excel -Video 421- VBA -Case Study – Powerful Arrays with 3 Loops

In-depth knowledge of Arrays And loops in this video. Extreme side of Arrays and using with three loops makes it[…]

Read More...