Jan 10 2021 04:39 PM - edited Jan 10 2021 04:41 PM
When extracting data from a database, I have some data that shows up as "LEI & EI" and when I try to search it using a countif formula it doesn't allow me. Is there a way to state in the criteria box for it to recognize the "&" sign with the word?