Excel Magic Trick #63: Boolean Logic & Array Formulas
See how to create Boolean Logic formulas for AND and OR. See Logical Truth Tables for AND and OR. See how to create Array Formulas in three different ways:
Array with SUM & IF functions (must use Ctrl + Shift + Enter)
Array with SUMPRODUCT function (DON’T have to use Ctrl + Shift + Enter)
Array with SUM function (must use Ctrl + Shift + Enter)
Dear JYC987654321,
That may be somewhat true. However, there are amazing exceptions. If you post questions to the MrExcel web site Discussion Board, there are people there that are incredible at both!
Give it a try.
–ExcelIsFun
I noticed that people who are really good with formulas and reports are not as versitle with macros. Also, I seen people who are experts in VBA that sucks with formulas.
Anyways, thanks for your help. I’ll join your website soon. I’m always eager to learn more excel.
Thanks,
JYC
Dear JYC987654321,
See above comment. For any Excel question in the universe, go to the MrExcel web site and join the discussion board.
–ExcelIsFun
Dear JYC987654321,
As I have said in other comments, I can hack my way through Macros and VBA, but I am not as good with that as I am with the Excel Surface (formulas, data analysis, Charts). I feel comfortable teach the surface stuff but not the Macro/VBA stuff. I have made a few videos on Macros. Search my site for Macros.
–ExcelIsFun
I’m trying to write a macro that selects the last item in a dropdown menu of a pivot table.
ex:
DATE (dropdown menu)
6/1/08
6/2/08
6/3/08
I need a macro that selects the last date from the dropdown menu.
Can you please help?
Are you good with macros by any chance?
Dear JYC987654321,
Keep watching and rating because I have a whole series of videos coming out on Array formulas over the next week!!!
–ExcelIsFun
Hey thanks for posting this. your first array formula helped me deal with a link function that I needed for weeks.