Mapping group of zip codes

crimsafemarketing 

I would suggest you to provide some sample of your data.

Because depending how it is organised, you can use just a MATCH() formula to get the groups.

1. Set the data

Open your Excel. Enter your data into the spreadsheet with ZIP codes and values; write them or copy from somewhere and paste.

If you prefer to do that with geography data type; input your data which includes geographical values, then go to Data > Data Types > Geography.

Your data will be converted into a geography data type. You can then add columns to the data, like population or tax rate.

2. Create the map chart

Once you finish arranging your data, select the cells you want to turn into the map.

Then on the Insert tab, go to Charts > Maps > Filled Map.

Here Excel reads the ZIP codes you entered and creates a map chart based on them. Relatively low values are represented by light colors and higher values are shown with darker colors.