Hi Alan.. great video. I've not used MOD much in the past, but your tips show me what I've been missing. For example, in the past I've always stripped decimal values with the combination of VALUE, MID and FIND. Now I'll use the single function of MOD instead.. so much easier and much more clever. And, summing or counting on every x rows.. Outstanding! As always.. Thanks and Thumbs up!
I enjoyed watching this video and recommend others. The host explains MOD function with examples. I know you have published lots of videos so my suggestion is as and when you express about your other videos better to display. Also, display related videos URL in the description box of this video Thanks a lot for educating the community.
Great. More uses for the GOD function. I've just come from an ExcelIsFun video using the *GOD* function (sorry, the MOD function) for calculating hours worked from start time and finish time including night shifts. MOD is a gamechanger for that too. Basically =MOD("finish time" - "start time" , 1) *24
Hi Alan, kindly mention any video link COUNTIF with unique record array explanation, like numbering the unique values or break up, i saw a formula =SUMPRODUCT((C3:C40"")/COUNTIF(C3:C40,C3:C40&"")) and =SUMPRODUCT(1/COUNTIF(C3:C37,C3:C37)) both are giving result unique number in column value, can you explain in detail?
Hi Majid, I have a video on the second formula you mention here - ruclips.net/video/x216dW2x5Gs/видео.html It is from 2014 so a little old. Hopefully explains it nicely.
WOW! Another great tutorial! Thanks so much for sharing your knowledge!
You are more than welcome Sandy.
Hi Alan.. great video. I've not used MOD much in the past, but your tips show me what I've been missing. For example, in the past I've always stripped decimal values with the combination of VALUE, MID and FIND. Now I'll use the single function of MOD instead.. so much easier and much more clever. And, summing or counting on every x rows.. Outstanding! As always.. Thanks and Thumbs up!
Thank you Wayne.
I enjoyed watching this video and recommend others.
The host explains MOD function with examples.
I know you have published lots of videos so my suggestion is as and when you express about your other videos better to display.
Also, display related videos URL in the description box of this video
Thanks a lot for educating the community.
Thanks Kris for the suggestion.
Great. More uses for the GOD function. I've just come from an ExcelIsFun video using the *GOD* function (sorry, the MOD function) for calculating hours worked from start time and finish time including night shifts. MOD is a gamechanger for that too. Basically =MOD("finish time" - "start time" , 1) *24
Nice work! MOD is fantastic.
@@Computergaga
I totally agree. Try calculating hours worked for day shift and night shift in the same sheet without MOD is a real ballbreaker.
Hi Alan, kindly mention any video link COUNTIF with unique record array explanation, like numbering the unique values or break up, i saw a formula =SUMPRODUCT((C3:C40"")/COUNTIF(C3:C40,C3:C40&"")) and =SUMPRODUCT(1/COUNTIF(C3:C37,C3:C37)) both are giving result unique number in column value, can you explain in detail?
Hi Majid, I have a video on the second formula you mention here - ruclips.net/video/x216dW2x5Gs/видео.html
It is from 2014 so a little old. Hopefully explains it nicely.
❤👍
💖