13:50 comma witch means go over to the next column and semicolon witch means go down to the next raw Very good info i never know before every time i learn new from you :)
@excelisfun
7 жыл бұрын
Awesome : ) Thanks for your continued support with comments and Thumbs Up : )
@75eneto
9 жыл бұрын
Another great lesson. Highly recommended .
@MalinaC
5 жыл бұрын
Mike, again thanks for the video. Lookup adding with SUMIFS is great!
@excelisfun
5 жыл бұрын
You are welcome Teammate Malina : )
@NeoJack-one
4 жыл бұрын
hello mike,thax again and again for these lessons :)
@excelisfun
10 жыл бұрын
Ctrl + Shift + Enter: Excel Array Formulas #06: Array Constants in Top 3 Formula using SMALL, SUMIFS formula, VLOOKUP, and Defined Names: 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 KZitem. 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!!!
@bernardobenvegnupasinatto7090
6 жыл бұрын
Differents ways to do the same thing... Very good professor
@ExcelVbaIsFun
10 жыл бұрын
Thanks for the vid!
@excelisfun
10 жыл бұрын
You are welcome, ExcelVBAisFun!
@prasitkeng001
4 жыл бұрын
What if I want to sum the score of the golfer, I tried to use formula =SUM(VLOOKUP("Verda Duhamel", $B$7:$E$12, {2,3,4}, 0)) I put the array constant in the formula but it still required CSE. I know that this could be achieved by using SUM and INDEX function, I just wonder why array constant does not work in this case.
@aknoimak
9 жыл бұрын
Thanks for lesson about array formula. :))))
@joem112
10 жыл бұрын
Hi Mike, Thank-you for the great series! Is there away to use an array constant as a list in data validation?
@excelisfun
10 жыл бұрын
You are welcome! For Data Validation, you don't need array syntax. The Sourc text box can take a list typed into it like: 1,2,3,4 Rad,Cool,Fun Try it, it is a great trick.
@joem112
10 жыл бұрын
ExcelIsFun Thank-you Mike. I was trying to find a way to save the list in an array like you did. Best i came up with was saving the list as a custom list. Then when i wanted the data validation list, i typed the first entry of the custom list and dragged it down. Then copy that list into the data validation source text box.
@excelisfun
10 жыл бұрын
Very cool!
@sosweet7543
6 жыл бұрын
awesome 😄
@planxlsm
5 жыл бұрын
4:12 9:16 13:40
@Clifffffffffford
5 жыл бұрын
👏🏽👏🏽👏🏽
@Clifffffffffford
5 жыл бұрын
Happy Thanksgiving 🦃!!! I’m thankful for good people like you who share their knowledge to others.
Пікірлер: 21