I’ve not used Excel or Calc much before other than seriously basic functionality. I’ve had a quick Google for what I need to do but the things I have tried (running a string in Basic) have not seemed to work yet. Thanks in advance.
Take a look at the notes on this question about Data Filters.
( @JohnSUN might also have a good suggestion