12 digit code sorting

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" <Mark@discussions.microsoft.com> wrote in message
news:F2E7D13F-F975-4B7B-9005-69D5933A312B@microsoft.com...
>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" <waxwing1@gmail.com> wrote in message
news:1130792998.752646.209450@g14g2000cwa.googlegroups.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