the important thing, I guess, is that the entire vlookup() it is based on the premise that two sales could not be done in the same second by two different salespersons, right?
Hello Jon! Can we use critera_range_1 like "Month(tblSales[Date])" and criteria_1 like "[@Month] when solving this problem with MINIFS function and without helper column? :-) :-) :-) I haven't had access to Excel 2016 yet neither at work and at home, so I can't check this myself. Regards!
Yeah, kinda made my head implode a bit. I will have to rewatch a few times to get my head around it as I don't have the subscription service so never encounter MINIF.
Too many formulas and functions at the same time... ...total chaos. The video IS NOT about MINIFS. It's about what you're trying to achieve using MINIFS.
Very very useful
Glad to hear that, thanks! 😀
the important thing, I guess, is that the entire vlookup() it is based on the premise that two sales could not be done in the same second by two different salespersons, right?
Can I use MINIFS function using data from different sheets?
Hello Jon!
Can we use critera_range_1 like "Month(tblSales[Date])" and criteria_1 like "[@Month] when solving this problem with MINIFS function and without helper column? :-) :-) :-) I haven't had access to Excel 2016 yet neither at work and at home, so I can't check this myself.
Regards!
With this challenge I have forgotten about MINIF
i found this one a little difficult to follow/understand
Yeah, kinda made my head implode a bit. I will have to rewatch a few times to get my head around it as I don't have the subscription service so never encounter MINIF.
Too many formulas and functions at the same time...
...total chaos.
The video IS NOT about MINIFS. It's about what you're trying to achieve using MINIFS.