I have a sheet with 2100 rows of information... Out of the 2100 records I want to find 19 of them using the skey column, which assigns a unique number to a customer. I have a list of the 19 skey numbers. When I turn on Auto Filter I can find one at a time, but how can I find or filter all 19 records all at once from the 2100, so only the 19 show, can I do that using Advanced Filter ?
I pasted the 19 records into a helper column.
Thanks for the help...
I pasted the 19 records into a helper column.
Thanks for the help...
Last edited: