View Single Post
  #16   Report Post  
Posted to microsoft.public.excel.programming
Max[_9_] Max[_9_] is offline
external usenet poster
 
Posts: 20
Default 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


Hi Claus, I am sorry to Trouble you again... Please have a look on this and can you tell me where I am Wrong please?

https://1drv.ms/x/s!AtAG_WNGGJX3gQbqM_6963w0n-sl

Thanks & Regards,
Max