View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default Comparison of Time

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