Thank you for covering so many new formulas in such a short time. It would also be helpful if you would produce videos on Excel recursive formulas like BYROW, BYCOL, REDUCE, MAP, SCAN, etc.
I’m glad you like this format. Thanks for the suggestion, those ones are conceptually more difficult to explain so I’m not sure it would work in the same format, I’ll consider it & some other functions too
Hi good question. It’s a bit counter intuitive but to do multiple AND criteria you need to multiply the criteria together. This discusses multiple criteria: www.spreadsheetclass.com/excel-filter-function/ & this video of mine shows nesting (& also how to keep headers & reorder columns) th-cam.com/video/GPUFFul536c/w-d-xo.html
Thanks David! the MMULT is used in finance and quite difficult, but did you know that in your example you could just use; range1 * range2 ? or =A5#*B4# that is it.
Thank you for covering so many new formulas in such a short time. It would also be helpful if you would produce videos on Excel recursive formulas like BYROW, BYCOL, REDUCE, MAP, SCAN, etc.
I’m glad you like this format. Thanks for the suggestion, those ones are conceptually more difficult to explain so I’m not sure it would work in the same format, I’ll consider it & some other functions too
Hello, would you be able to show a nested example of a =SORT(FILTER( using multiple filters?
Hi good question. It’s a bit counter intuitive but to do multiple AND criteria you need to multiply the criteria together. This discusses multiple criteria: www.spreadsheetclass.com/excel-filter-function/ & this video of mine shows nesting (& also how to keep headers & reorder columns) th-cam.com/video/GPUFFul536c/w-d-xo.html
@@learnspreadsheets I did figure it out. As a finance person, I wanted to automate commentary for my use case in my work.
Thanks David! the MMULT is used in finance and quite difficult, but did you know that in your example you could just use; range1 * range2 ? or =A5#*B4# that is it.
Cheers Bart! Yes great suggestion - that’s another way the formula could have worked