Take a look at the conditional formatting. I filled the area starting with the first row where A appears with n then used the conditional formatting to change the colour of the n where there was a match to the background colour thereby making it appear to not be there.
Bookmarks