Excel filter question??

[easyhome]

Is there a way to filter this so it only shows the packs numbered 1?

So in the below, where there are 3 packs numbered 701, I only want to see 701/1, and so on.

Really hoping this is possible.

TIA.

[simon_harris]

quick and dirty you could text to columns split the second column and then filter on the 1's

[mmm-five]

Yes.

Simply put a filter (from the Data menu/toolbar) on the columns and then filter by [contains] and then type "/1" as the filter.



(screenshot from Mac version so window looks different, but process is the same)

[Mr Pointy]

Learn about Filters:

https://support.microsoft.com/en-us/office/quick-s...
https://duckduckgo.com/?t=ffab&q=CREATE+EXCEL+...

[easyhome]

Thanks All.

mmm-five, took me a while as on Windows you have to put in a * (so "*/1") to represent the other numbers, but I got there in the end!

Cheers.

[sgrimshaw]

Just use a text filter "contains" /1:

[mmm-five]

The only reason where you'd need the asterisk would be if you're using 'is' instead of 'contains' or if you're not doing it by the autofilter route and putting it into a formula.