| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hiding rows based on character recognition
I have a spread sheet which can vary from 8k to 12k lines long.
Row 1 contains header information. Excel 2003. Column F contains random data, for lack of a better term I'll call them serial numbers. I need to run through all of the rows, and look at the first character in the serial number in Column F. If the first character is "8", I need to hide the entire row. Can anybody provide help with this? Many thanks in advance! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| PICTURE RECOGNITION AS A ALPHA-NUMERIC CHARACTER | Excel Worksheet Functions | |||
| PICTURE RECOGNITION AS A ALPHA-NUMERIC CHARACTER | Excel Worksheet Functions | |||
| PICTURE RECOGNITION AS A ALPHA-NUMERIC CHARACTER | Excel Worksheet Functions | |||
| Hiding Specific Rows Based on Values in Other Rows | Excel Worksheet Functions | |||
| Hiding rows based on a value | Excel Discussion (Misc queries) | |||
Threaded Mode
