Forum Discussion
Count of Interval of Occurances
Hi Team , Below is my my scenario. I am looking for a formula which will tell me the count of the interval between the 1st and 2nd occurrences . As you can in the above screen shot the dat...
=IFERROR(SMALL(IF(B2:M2<>"",COLUMN(A:L)),2)-SMALL(IF(B2:M2<>"",COLUMN(A:L)),1)-1,0)
Maybe with this formula which works in my spreadsheet. Enter the formula as arrayformula with ctrl+shift+enter if you don't work with Office365 or 2021.
- Thank you so much !!
It works
