A_MrExcel.xlsm | ||||||||
---|---|---|---|---|---|---|---|---|
C | D | E | F | G | H | |||
1 | ||||||||
2 | FALSE | |||||||
3 | ||||||||
4 | Hdr 1 | sec. ID | Hdr 3 | Hdr 4 | ||||
5 | data | 3824 | data | data | ||||
6 | data | H35 | data | data | ||||
7 | data | 65025 | data | data | ||||
8 | data | XD87865R | data | data | ||||
Adv Fltr |
Cell Formulas | ||
---|---|---|
Range | Formula | |
H2 | H2 | =NOT(ISNUMBER(LEFT(D5,1)+0)) |
A_MrExcel.xlsm | ||||||||
---|---|---|---|---|---|---|---|---|
C | D | E | F | G | H | |||
1 | ||||||||
2 | FALSE | |||||||
3 | ||||||||
4 | Hdr 1 | sec. ID | Hdr 3 | Hdr 4 | ||||
6 | data | H35 | data | data | ||||
8 | data | XD87865R | data | data | ||||
9 | ||||||||
Adv Fltr |
Cell Formulas | ||
---|---|---|
Range | Formula | |
H2 | H2 | =NOT(ISNUMBER(LEFT(D5,1)+0)) |
In that case could we see the code you are currently using and some sample data so we can see the layout and where/how you are using those headers in your criteria?using VBA advanced filter relying on headers