Ctrl + Shift + Enter: Excel Array Formulas #07: Introduction To Array Functions. TRANSPOSE Function

EXCEL ARRAY FORMULAS WORK THE SAME IN ANY VERSION OF EXCEL!!!

This video covers:
1. (00:30 min) Array Function Overview. TRANSPOSE Array Function to deliver more than one value to more than one cell.
2. (01:51 min) Formula goal: Transpose (Link to vertical data source and show values horizontally).
3. (05:30 min) TRANSPOSE and IF to avoid zeros (0).
4. (08:49 min) Calculating notes about Array Formula that use TRANSPOSE Array Function.
5. (08:07 min) Array Functions guidelines.
THIS VIDEO SERIES AT YOUTUBE IS THE SAME AS THE DVD FROM EXCELISFUN. THESE VIDEOS ARE BEING GIVEN AWAY FOR FREE AT YOUTUBE. SUPPORT THE CAUSE BY GOING TO AMAZON AND BUYING THE BOOK.
EXCEL ARRAY FORMULAS WORK THE SAME IN ANY VERSION OF EXCEL!!!
Ctrl+Shift+Enter: A Book About Building Efficient Formulas, Advanced Formulas, and Array Formulas for Data Analysis and Calculating Problems
Designed with Excel gurus in mind, this handbook outlines how to create formulas that can be used to solve everyday problems with a series of data values that standard Excel formulas cannot or would be too arduous to attempt. Beginning with an introduction to array formulas, this manual examines topics such as how they differ from ordinary formulas, the benefits and drawbacks of their use, functions that can and cannot handle array calculations, and array constants and functions. Among the practical applications surveyed include how to extract data from tables and unique lists, how to get results that match any criteria, and how to utilize various methods for unique counts. This book contains 529 screen shots.

[rodrigocustodio]

Few individuals in life have contributed so much to benefit others as Mike has done, top classes, top materials, all for free. Thank you, Mike!

[excelisfun]

Ctrl + Shift + Enter: Excel Array Formulas #07: Introduction To Array Functions. TRANSPOSE Function 
This video is the same as the video on the Ctrl + Shift + Enter: Mastering Excel Array Formula DVD, but it is being given away for free here at YouTube.
To Support the cause, go to Amazon and buy the book or DVD. Book and DVD title: Ctrl + Shift + Enter: Mastering Excel Array Formulas.
There are 25 videos in this series (0 to 24).
Remember: Excel Array Formulas work the SAME in any version of Excel!!!

[ShakeelAhmed-zdpq]

Thanks a lot Sir, you are my teacher, now i can earn my bread and butter easily, God bless you

[walterclam]

Thanks a lot Mike!
BTW, / TRANSPOSE(B23:E25)&"" should be easier =)

[kwonpv]

Watching your videos gives me much of inspiration. I'm trying to find an excel solution for my work but still get stuck. May I send you an email to ask something? Thanks so much for your help

[miketyworth]

Why not use ISBLANK on the third problem where you want empty cells to be left as empty on the transposition?

[rosecykewick]

So, I'm losing my mind trying to find a formula to simplify my work.

Generally, I need a formula which will count the nonblank cells in Column C, if Column A = "x", and Column B = "y".

Specifically, I need a formula which will count the number of results for a particular date range on a particular shift:
A B C
Date Shift Result
1/1/16 1 2
1/1/16 2 0
1/1/16 3
1/2/16 1 0
1/2/16 2 1
1/2/16 3 1
1/3/16 1 0
1/3/16 2
1/3/16 3 0
ETC...

Let's assume I need total number of results for 1st shift in 1st quarter (assume "etc" dates continue thru the remainder of the year). For the values shown, I'd have 2, 0, 0 which is a total of 3. For 2nd shift 1st quarter, I'd have 0, 1, "blank" which is a total of 2. I'm thinking there's gotta be an array that will help with this.

Any help that anyone can provide would be much appreciated.