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...
If you prefer for a spreadsheet then I can..... this has very limited data and I don't know if it will impact anything...
I didn't realise a screenshot would be an issue.
laurenwhelan Looks like all your addresses have the post code as the last four characters. In that case, there's a relatively simple formula, see attached. I added an extra column on the right-hand side of the table and I converted your post code list to a table as well (tblPostCodes).
