Forum Discussion
Multiple search and conditional formatting
I have a weird one: - I have a spreadsheet with patient names, addresses etc. - I need to filter out all postcodes. I have a list of post codes for post codes within an "allowed" area and ones that...
Looks as if the post codes are always the last four characters in the cell? Anyway, if you ask an Excel question, why not attach an Excel file, not a screen-shot.
Yes that is right and Because I had to redact a lot of information..... just to get the screenshot while keeping the quality of the data there
