4 Excel MOD Function Examples - Excel Formula Tutorial

WOW! Another great tutorial! Thanks so much for sharing your knowledge!

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 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.