Forum Discussion
Thomas Hewitt
Sep 24, 2017Copper Contributor
Formatting filters. How do I do it?
Hi everyone. I want to format a filter so that it can pick up things with certain serial numbers if that's possible?
Essentially, I've got a column that's full of serial numbers for products but some of them are for different production lines (for example one product starts 02x followed by random numbers, and another starts 08x).
Is there a way to format my filter options so that when I click the drop down arrow I get the option to have 02x, 08x etc and not the hundreds of complete serial numbers that are in that column?
Cheers
Thomas,
insert a helper column and filter this column.
=LEFT(A2,3)
- Detlef_LewinSilver Contributor
Thomas,
insert a helper column and filter this column.
=LEFT(A2,3)
- Thomas HewittCopper Contributor
Thanks for coming back to me Detlef. I appreciate your help.
You've solved my problem and for that you're an absolute star. Thanks very much.