We want a count on how many people live in each zip code in the attached file. It has one person per row. They just want a total for each zip code. BUT the zip codes are XXXXX-YYYY...Can I count the unique codes for just the first 5 digits (not the YYYY).
You may create a helper column to extract the 5 digits from the zip codes and then insert a Pivot Table to get the count for each 5 digit zip code as shown in the attached file. Filter the Pivot Table to exclude the blank empty zip code and other not desired zip codes and then sort it in descending order.