An alternative to the limited vba Mod() function. One of the (multiple) probelms with Excel VBA's Mod() function is that it does not support decimals. Mod() will evaluate a single or double as an ...

A mix of Excel functions will allow me to do this. Functions like SumProduct (), Mod () and Row (). I will provide an example that has data that doesn’t start in cell A1, but somewhere else on the ...