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

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

Chip - what do the two dashes mean before the MID function. I've seen
this in some SUMPRODUCT formulas but don't understand the significance.

Thanks

- John Michl

I found the answer in an earlier post.

http://groups.google.com/group/micro...6d4a22041ba61b

The MID function returns a string/text result. The -- converts
the text result to a number.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"John Michl" wrote in message
oups.com...
Chip - what do the two dashes mean before the MID function.
I've seen
this in some SUMPRODUCT formulas but don't understand the
significance.

Thanks

- John Michl

How'd you get 90,000 rows of data?

Mark wrote:

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

--

Dave Peterson