I set up an autofilter on a sheet for logging drill holes for a seismic drill company so I could easilly browse and search the sheet. However, the "begins with" in the custom part of the filter doesn't seem to work.
for instance, a hole is broken up into 2 numbers, the line number and the hole number
Line 5137, hole 1162
so the whole number is 51371162
Now I need to enter that hole as logged but, there are also other holes beginning with 5137 that I need to log today, but when I search for begins with 5137 the entire sheet comes up blank. Any suggestions?
God Bless,
Chris
for instance, a hole is broken up into 2 numbers, the line number and the hole number
Line 5137, hole 1162
so the whole number is 51371162
Now I need to enter that hole as logged but, there are also other holes beginning with 5137 that I need to log today, but when I search for begins with 5137 the entire sheet comes up blank. Any suggestions?
God Bless,
Chris