Concept Courtesy: Nidhin Mehta www.engineers-excel.com/Apps/Digital_Rain/Description.htm For a detailed explanation of the formulas used and to download the Excel file xlncad.com/matrix-digital-in-excel/
Thank you. All credit goes to Mr. Nidhin Mehta www.engineers-excel.com/Apps/Digital_Rain/Description.htm My contribution was automating the process with a Macro.
@@saleemmohammad1287 I went through the site of Microsoft and found the following code. I am sharing the link for the article too. Hope it helps. #If VBA7 Then Private Declare PtrSafe Sub Sleep Lib "kernel32" (ByVal ms As LongPtr) #Else Private Declare Sub Sleep Lib "kernel32" (ByVal ms as Long) #End If docs.microsoft.com/en-us/office365/troubleshoot/compile-error-editing-vba-macro