12 digit code sorting

M

Mark

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
 
C

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
 
D

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
Click to expand...
 
J

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
 
C

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
 
Top