Hello,
I have a list of account numbers in the format of "XXXX-YYY-ZZZ- -" in column A, specifically A6-A684.
Is there a function in excel, similar to Vlookup, that would pull out any and all account numbers that match a certain criteria?
For instance, ideally, I would want to pull out any...