My data is 9 columns by 1044 rows. Column 1 is the "Location Code" for each row of data. "Location Codes" repeat as column 2 has eight possible values. I have a criteria list of Location Codes for which I only want to see data for.

Once filtered, I then want to Subtotal the numerical values in column 3 by "location code" (column 1). I'd like the subtotal list by location code to be displayed seperate from the data.

I've made multiple attemps to use the Advance Filter option and don't seem to be doing it correctly. Any help is welcome.