In a new column, enter the formula
=--MID(A2,4,2)=18
and copy down as far as you need to go. Then, filter on TRUE
values in this column.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"Mark" wrote in message
...
I have a list of 90,000 12 digit records. I need to count the
number of time
the fourth and fifth digit are 1, 8 (or 18) and, if possible,
filter my
spreadsheet to hide to rows not meeting this criteria.
Mark