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...
Hi
Thanks for the message.
While I was waiting for a reply, I ended up doing a Find for all postcodes that were within the numbers I needed and then highlighted them in yellow. Then I Chose to Hide all the rows that had no fill. It was a long way of doing it as there are 83 post codes that I needed to filter for Invalid/out of area post codes.
I have attached some screen shots. Unfortunately, the address column has the street number and name in it and cannot be separated otherwise it would be a sinch! I have replaced the street name and number with "123 None Street" so you can see the formatting etc...
Thanks for your help, I really appreciate it
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.
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).
- 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
