Identifying Consecutive Entries

[Renee]

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!