12 digit code sorting

[Guest]

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 Pearson]

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

 

[Dave Peterson]

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

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

 

[John Michl]

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

 

[John Michl]

I found the answer in an earlier post.

http://groups.google.com/group/micr...81afd/836d4a22041ba61b?hl=en#836d4a22041ba61b

 

[Chip Pearson]

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