Excel: Consecutive 3 Occurrences or more of a value in a string

by

Using Base R:
rle function compute the lengths and values of runs of equal values in a vector.

x <- c(1 ,0 ,0 ,0 ,1 ,1 ,0 ,0 ,1 ,0 ,1 ,0 ,0 ,0 ,0 ,1 ,1)
rlx <- rle(x)

rlx
Run Length Encoding
    lengths: int [1:9] 1 3 2 2 1 1 1 4 2
    values : num [1:9] 1 0 1 0 1 0 1 0 1

sum(rlx$lengths[x==0] >=3, na.rm = TRUE)
[1] 2

PS: @Mr. Down voter answer posted as OP “Original post” includes R tag.

More Related Contents:

  1. how should I apply a formula and get answer in all the odd cells?
  2. Sequence of numbers based on start and end value of 2 cells [closed]
  3. Error in finding last used cell in Excel with VBA
  4. Excel VBA, getting range from an inactive sheet
  5. Is there a way to crack the password on an Excel VBA Project?
  6. How do I declare a global variable in VBA?
  7. How to use the Implements in Excel VBA
  8. VBA code doesn’t run when cell is changed by a formula
  9. What is the difference between dim and set in vba
  10. Change date format using substitute or replace
  11. Getting the actual usedrange
  12. How to export a CSV to Excel using Powershell
  13. VBA: Convert Text to Number
  14. Iterating through populated rows
  15. Using VBA to detect which decimal sign the computer is using
  16. Referencing Excel Userform Control Name Value From String (VBA)
  17. Fill formula down till last row in column
  18. If string contains word from list, return value adjacent to list value
  19. Refreshing all the pivot tables in my excel workbook with a macro
  20. Countif With Multiple OR Criteria
  21. Vlookup to copy color of a cell
  22. excel vba freeze pane without select
  23. Converting a string representation of a constant into a constant?
  24. Macro to export MS Word tables to Excel sheets
  25. VBA WinHTTP to download file from password proteced https website
  26. Generate N random numbers whose sum is a constant K – Excel
  27. How do I read data from a spreadsheet using the OpenXML Format SDK?
  28. Delete all data rows from an Excel table (apart from the first)
  29. Excel Hide/Show all tabs on Ribbon except custom tab
  30. Excel VBA Run-time Error ‘32809’ – Trying to Understand it

Leave a Comment