I call this a "multi-row filter/sort" because that's the best name I
can think of. I think it's more of a filter than a sort. I've hacked
at this for quite a while and haven't come up with a solution yet.
Please help if you have a minute. Here's the problem:

I have a spreadsheet with several thousand rows and about 30 columns.

In Column G, a value is present, ranging from 0 to 100.

I need some kind of formula or routine that will scan down Column G
and find any instances where a value 30 (greater than 30) occurs in
Column G three or more times in a row.

The result needs to be a spreadsheet containing ONLY these rows.

For example:

A B

aaa 25
bbb 27
ccc 38 <
ddd 31 <
eee 48 <
fff 12
ggg 58 <
hhh 41 <
iii 11
jjj 59 <
kkk 72 <
lll 93 <
mmm 88 <
nnn 18
ooo 21

Would produce:

A B
ccc 38
ddd 31
eee 48
jjj 59
kkk 72
lll 93
mmm 88

Would be very grateful for an answer. Please reply to the group only.

Thanks,
Ron M.