Variable reference to noncontiguous cells...
Hi,
Am Thu, 30 Jan 2020 15:47:44 -0600 schrieb dpb:
This averages all the cells between MC:AC7, not just those for which
MOD(...,4)=1.
no, I tested it and it only averages the cell in M, Q, U, Y, AC
Regards
Claus B.
--
Windows10
Office 2016
|