Comparison of Time
On Tuesday, 15 August 2017 14:38:14 UTC+5:30, Claus Busch wrote:
Hi Max,
Am Tue, 15 Aug 2017 01:40:59 -0700 (PDT) schrieb Max:
WOW, Great....Claus, Thanks you made the solution.. Though I need to learn on the Sum Product Function as well as MOD Function..... As I am not clear that why divisor is 3... If you can Explain.
you want check every 3rd column. Therefore you have to divide the column
number by 3.
MOD(COLUMN(B3:CR3),3)=2
is true for columns 2, 5, 8, 11 and so on.
Regards
Claus B.
--
Windows10
Office 2016
Thanks Really Appreciates your involvement in resolving my problem...
|