ExcelBanter - Identifying Consecutive Entries

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Identifying Consecutive Entries (https://www.excelbanter.com/excel-discussion-misc-queries/118724-identifying-consecutive-entries.html)

Renee

Identifying Consecutive Entries

Is there any way to identify consecutive entries only? I have columns that
may have "Wilson" entered 20 times, but I only want to "identify, count,
etc.) where "Wilson" appears in 3 consecutive rows?

Thanks for the help!

All times are GMT +1. The time now is 09:05 PM.